CODEWITHSUNDEEP
mulemule4
Bibek Kr. Bazaz
Bibek Kr. Bazaz

Reputation: 545

Mule 4 : Getting error while reading CSV file, Malformed Input

I am reading a CSV file using File READ operation in Mule 4. One of the CSV columns has double quotes in its values. While reading the CSv file I am getting the error :

Malformed CSV input. Ignoring following chars after quoted value at offset 45270921: "A"" BLING KEY RING"

I tried by adding reader property quote with following values : """ , " "

Still the error exists, Please help

Upvotes: 0

Views: 1028

Answers (1)

aled
aled

Reputation: 25699

Try setting the escape reader property to a quote. Reader properties must be set at the source of the payload.

Example:

<file:listener doc:name="On New or Updated File" config-ref="file_config1" outputMimeType='application/csv; escape="\""' directory="/some/path/to/file" recursive="false" >

Upvotes: 2

Related Questions