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(""e",""), 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 "\""
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 ****
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.