Concatenate a URL and a regular string

Neo4j Graph Platform Cypher
1

I have 2 properties:
s.url which is a string containing a url
r.date which is a string containing a year

I want to concatenate these into one string, but with + as well as with apoc.text.join([s.url, ', ', r.date], ' ') the whole string, including the comma and the date, is turned into a URL:
Schermafbeelding 2023-05-11 110511

How can I add the ', 2021' to the string with it being added to the url, like this:
Schermafbeelding 2023-05-11 110831

(used screenpics because I can't reproduce the 2 formats here :slight_smile:)

Thanks for any suggestion!

2

Sorry, I am confused on what you are asking. Does the apoc join not give you thecresults you desire?

3

That is correct: both the simple "+"-operator and the apoc turn the full string into an url

4

What is the “suggestion” you are seeking? Did you not get the proper URL with each approach?

5

ĂŹ double-checked: the problem only seems to occur in NeoDash, when I run the query in Browser, everything works fine. Sorry.

1 Like