cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! Site migration is underway. Phase 2: migrate recent content

Is there a function to test whether a string is ascii only?

lingvisa
Graph Fellow

I don't see it in string functions, not in APOC either.

Please confirm it and I will have to do it outside of neo4j. Those functions are very helpful though.

1 ACCEPTED SOLUTION

dana_canzano
Neo4j
Neo4j

Have you considered

apoc.text.clean(text)

strip the given string of everything except alpha numeric characters and convert it to lower case.

and thus something similar to

match (n:Movie) where apoc.text.clean(n.title)=n.title return n;

or is this giving you issues as well

View solution in original post

1 REPLY 1

dana_canzano
Neo4j
Neo4j

Have you considered

apoc.text.clean(text)

strip the given string of everything except alpha numeric characters and convert it to lower case.

and thus something similar to

match (n:Movie) where apoc.text.clean(n.title)=n.title return n;

or is this giving you issues as well