AnsweredAssumed Answered

Remove single quote in GEL

Question asked by Fabio Cresta Employee on Sep 1, 2016
Latest reply on Sep 2, 2016 by Fabio Cresta

Hi All.

I need to load resources from a CSV file. Some names contain a quote (i.e.: ANGILE' FABRIZIO), and I have the same into PPM resources (I mean, I have the quote too).

I have a query with the following WHERE condition:


WHERE full_name='${userRead}'


When the full name contain the single quote, I get an error, since the statement is transalted into




I'm not able to find a way to remove the quote using replace function in gel (userRead.replace(....)).

Any suggestion would be greately appreciated.