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

 

 WHERE full_name='ANGILE' FABRIZIO'

 

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.

Thanks

Fabio

Outcomes