SyntaxError at the p of Replace

Neo4j Graph Platform Cypher
1

Hello,
I am getting a really strange error and cant find a solution for it.
Neo.ClientError.Statement.SyntaxError

Invalid input 'P': expected 'm/M' or 't/T' (line 2, column 3 (offset: 2))

"REPLACE(ProductLocation._productionTypeId, 'CS-'','')"

My Code ist basically just:

MATCH(p:ProductLocation)
REPLACE(p._productionTypeId, "CS-","")
RETURN p LIMIT 1

It is really weird, Thank you for your help in advance
Nils

2

Hi @nils.hahn

If your requirement is to update the property value then you need to set that
eg.
MATCH(p:ProductLocation)
set p._productionTypeId = REPLACE(p._productionTypeId, "CS-","")
RETURN p LIMIT 1

1 Like
3

Thanks a lot, that worked! Damn that I missed that.