[resolved] Escape quotes in tMap?

[Anonymous]

Hello community,
I need to escape quotes but i have a problem.
I was tried this with replace and replaceAll ("\"","") but doesn't work, i was tried too with replace("&quote",""), but doesn't work
I need remove this quotes before to upload my data, can you help me please?
Thanks in advance
Edit: CSV options:
->field separator: "/t"
->Text enclosure "\""
->Escape char "\""

[bkar81]

Have you tried with tReplace component?
While using it, please uncheck 'whole word' option.
Input Column: Column where this special character has to be removed
Search: The character to be removed (here it is "\"" )
Replace With: ""
Whole Word: Uncheck it ****

[Anonymous]

ok, i read the edit now. I will try it and i will post the result
Thanks!

[bkar81 · Accepted solution]

Place a tReplace component after the source and as mentioned above configure that component. The output of that component will not have the escape/special character. Put a tLogRow component as the output to tReplace and you can check the result.
Once confirmed, put the real output component like DB output or flat file output
Cheers.

[Anonymous]

I try it and now its works! thank you so much bkar!
Best regards, Víctor

[bkar81]

Nice to hear that it works for you...
Happy coding..
Please mark this post as resolved...
Cheers,
Karthikeyan

[Anonymous]

sorry i was working in a client and i haven't time, i click on "Set this topic as resolved" but idk if this works, sorry! I have little skill..

[HungryOctopus]

I had the same problem in a tmap and .replace(" \"", "") worked fine for me.