apoc.text.clean

Function

apoc.text.clean(text String) - strips the given string of everything except alpha numeric characters and converts it to lower case.

Signature

apoc.text.clean(text :: STRING?) :: (STRING?)

Input parameters

Name Type Default

text

STRING?

null

Usage Examples

RETURN apoc.text.clean('Hello World!') AS output;
Table 1. Results
output

"helloworld"

 
RETURN apoc.text.clean('Hello___World!') AS output;
Table 2. Results
output

"helloworld"

 
RETURN apoc.text.clean('$-Hello___World!$') AS output;
Table 3. Results
output

"helloworld"