Say we have a file named input.csv containing the following text:
"
col_A
";"
col_A
2";col_B
1;2;3
4;5;6
If I try to execute the following instruction (using C#)
var f = Frame.ReadCsv("input.csv", separators: ";");
I can observe, by placing a breakpoint right next to it, that f.ColumnKeys elements are equal to [ "col_A", "col_A\r", "col_B" ], meaning that the method isn't correctly parsing the header.
In another scenario I even got a System.ArgumentException telling me that a duplicate key was found (the scenario was similar to the one I provided above, but I can't replicate that case using a simple example at the moment).
Looking at the csv standard (RFC-4180: https://tools.ietf.org/html/rfc4180), I couldn't find any mentions about the impossibility to have multiline column names, so I assume that it should be possible.
Say we have a file named input.csv containing the following text:
If I try to execute the following instruction (using C#)
var f = Frame.ReadCsv("input.csv", separators: ";");I can observe, by placing a breakpoint right next to it, that
f.ColumnKeyselements are equal to[ "col_A", "col_A\r", "col_B" ], meaning that the method isn't correctly parsing the header.In another scenario I even got a System.ArgumentException telling me that a duplicate key was found (the scenario was similar to the one I provided above, but I can't replicate that case using a simple example at the moment).
Looking at the csv standard (RFC-4180: https://tools.ietf.org/html/rfc4180), I couldn't find any mentions about the impossibility to have multiline column names, so I assume that it should be possible.