cancel
Showing results for 
Search instead for 
Did you mean: 

How to remove Escape character while file writing CSV formatter

Akhil
New Contributor

I am trying to write a file with custom header separated by semi-colon (reading header from expression library as string)followed by data.
While writing using CSV formatter escape character ‘\’ is getting added as prefix for ‘;’.

Please suggest how i can remove this ‘\’

image

5 REPLIES 5

@Akhil if you are interested only in data , try using .replaceAll(“,” , “;”) in Mapper after Parser.

You will get data something like this : Candace;Kelley;10/29/21;160206159956;Dalbeattie;Customer Relations

Hope this helps.