Replace regular expressions in cypher

Question

I can search for regular expressions in cypher

MATCH (n:model) WHERE n.name =~ '.*&.*;.*' RETURN n.name

but can I also replace them? I would like to write something like

MATCH (n:model) RETURN replace(n.name, ~'&.*;', '_');

Answer 1

There is a replace function in cypher, but it does not replace regexps, just simple strings. Maybe a feature request for replaceRegex could be done?

An workaround would be to do this programatically, after you return the names (if you use call cypher queries from another application).