Forum Discussion

Akhil's avatar
Akhil
New Contributor
5 years ago

How to remove Escape character while file writing CSV formatter

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 ‘\’ i...
Akhil's avatar
Akhil
New Contributor
5 years ago

I am reading header details from expr file as below
header:“header1;header2;header3”
since my delimiter is ; CSV formatter is prefixing escape character() to my header ‘;’

If i am replacing with(,) it to header:“header1,header2,header3” its working as expected but my business requirement is to have delimiter as ;

  • nishantagarwal's avatar
    nishantagarwal
    New Contributor II
    5 years ago

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