APOC - apoc.periodic.iterate - Using split function

[mattfrisbee]

Hello,

I was wondering if it is possible to call the 'split' function or 'apoc.text.split' inside an apoc.periodic.iterate.

When using either split function, we get the following error:

For our application, we are creating nodes via Java & APOC and need to set property values as lists. They are currently being stored as Strings such as "["val1","val2"]". Is there a way to utilize either split function or another alternative for our use case? Thank you so much!

[glilienfield · Accepted solution]

Use single quotes to enclose both query strings.  You are getting the issue because the double quotes around the comma 

[mattfrisbee]

Thank you so much, this fixed our issue! I really appreciate it!

[glilienfield]

Btw. Cypher has a split function 

https://neo4j.com/docs/cypher-manual/current/functions/string/#functions-split