topic [resolved] Escape quotes in tMap? in Talend Studio

[resolved] Escape quotes in tMap?

Anonymous — Thu, 06 Mar 2014 12:41:55 GMT

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 "\""

Re: [resolved] Escape quotes in tMap?

bkar81 — Thu, 06 Mar 2014 12:51:13 GMT

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 ****

Re: [resolved] Escape quotes in tMap?

Anonymous — Thu, 06 Mar 2014 13:00:12 GMT

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

Re: [resolved] Escape quotes in tMap?

bkar81 — Thu, 06 Mar 2014 13:03:11 GMT

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.

Re: [resolved] Escape quotes in tMap?

Anonymous — Thu, 06 Mar 2014 15:15:24 GMT

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

Re: [resolved] Escape quotes in tMap?

bkar81 — Thu, 06 Mar 2014 15:33:51 GMT

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

Re: [resolved] Escape quotes in tMap?

Anonymous — Wed, 09 Apr 2014 17:23:14 GMT

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

Re: [resolved] Escape quotes in tMap?

HungryOctopus — Thu, 07 Mar 2024 09:27:39 GMT

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