apoc.text.clean

Function APOC Core

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

Signature

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

Name	Type	Default
text	STRING?	null

Name

Type

Default

text

STRING?

null

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"