If I have a CSV with a notes field of some sort and that notes field includes newline characters, CscDataReader interprets those as signifying the beginning of a new row of data, even though the newline characters are inside the text qualifiers. This causes an indexoutofrangeexception to be thrown.
I would love to see the tool be able to qualify not just the separator character but newline characters as well to handle this scenario.
If I have a CSV with a notes field of some sort and that notes field includes newline characters, CscDataReader interprets those as signifying the beginning of a new row of data, even though the newline characters are inside the text qualifiers. This causes an indexoutofrangeexception to be thrown.
I would love to see the tool be able to qualify not just the separator character but newline characters as well to handle this scenario.