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:
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.