Replace "'" by """ ?

[Eric_Talend]

Hello,

I have an string variable and I would like to replace the character ' (simple quote) by the character " (double quote).

I would like to do this in tMap but it doesn't work :

StringHandling.EREPLACE(row3.Y2_00555,"'",""")

How can I do this ?

Thanks.

Regards;

[XJ_1630]

i am not sure that i understand:

did you try - StringHandling.EREPLACE(row3.Y2_00555

,"'"

,"\""

)

• the lack of back-slash in front of your double-quote might be a issue

[Eric_Talend · Accepted solution]

You understood.

I had found this solution and I was going to post it !

So, I confirm 😉

StringHandling.EREPLACE(row3.Y2_00555, "'", "\"")

it's OK 😉

Many thanks