I'am trying to parse a CSV but the column names contain new lines and I'am struggling to find a proper solution.
If I have the following csv header for example:
"Column 1 \n(this has valuable info)","Column 2","Column 3" \n
and I split by the new line character it will take in account the new line within the quotes as well causing the whole header to be split into multiple lines.
Is there a way that I can ignore the \n characters in double quotes with a regex? The ones that I've tried by searching in Google threw the 'Regex too complicated' error.