CSV and double qoutes

I am trying to import a CSV file by using the CSV filter in Logstash. This works fine, but in the description field I sometime have special characters, like " (double quotes), so this gives a parse failure. How can I solve this?

Please show an example.

INVOICE DATE ARTICLE DESCRIPTION
40 28-4-2017 25107948 BAMBOO 6" LID
50 28-4-2017 25107939 BAMBOO 6" STEAMER

The " gives problems

Well, since you have separator characters (spaces) occurring inside the field values I'm not sure the csv filter is a great match anyway. In this case I'd use a grok filter.

Ok, I'll try that. Thnx Magnus!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.