Forum Discussion

Akhil's avatar
Akhil
New Contributor
4 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
4 years ago
Copy LinkReport

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
4 years ago
Copy LinkReport

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

  • dmiller's avatar
    dmiller
    Former Employee
    4 years ago
    Copy LinkReport

    Hi @Richard,

    We may need a bit more information of how your pipeline is configured. Is the message coming directly into a RabbitMQ Consumer Snap or do you have something before it?

  • Supratim's avatar
    Supratim
    Contributor III
    4 years ago
    Copy LinkReport

    @Richard If I understand your question correctly, you can refer below steps-

    1. Open Rabbit MQ consumer snap and go to view tab . Select error view option
    2. Add mapper for custom error message and then right click on mapper. Then select Link output to Error Pipeline. It should pass your custom message to error pipeline.

    Hope it might help you.