APOC - apoc.periodic.iterate - Using split function

Integrations
1

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:

mattfrisbee_0-1664216228818.png

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!

2

Btw. Cypher has a split function

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

3

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

4

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