Field enclosed in quotes


I have a csv file where one of the attributes is enclosed in quotes. It contains lyrics of songs and so it can contain the csv separator symbol ("," and ";") and line ends.

How do I parse this attribute correctly?
Logstash throws csvparsefailure errors because of the quotes and although I've seen posts about replacing the quote_char, doing so would mean once Logstash enconters a separator or lineend that is part of the song lyric, it will view it as another attribute.

Example of an entry in the csv file:
artist, song, lyrics
this is an artist name, this is a song name, "lyrics for, a song;
it can have lineends

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