You can translate the question and the replies:

How do I replace special characters in a string?

I have a string which includes single quotes which I'd like to remove using the REPLACE function, but I'm not clear what escape characters are required to do this e.g.REPLACE(field, '[esc]'', '') I have also tried creating a MAP to also do this replacement, but I seem to have the same issue.
string conversion
user
29-12-2021 13:24:38 -0500
code

1 Answer

Hi, I would use replace function with the format REPLACE(field_name,'''','') to remove single quotes. Hope this helps!
Denodo Team
30-12-2021 07:15:20 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here