SyntaxError at the p of Replace

[nils_hahn]

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

[intouch_vivek · Accepted solution]

nils.hahn:

MATC

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

[nils_hahn]

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