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