How to remove Escape character while file writing CSV formatter
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-17-2021 12:20 AM
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 ‘\’
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-17-2021 11:39 AM
@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.
