Reading CSV with byte order mark bleeds into first Column Name

[janseeger]

If you try to read a CSV file that begins with a BOM, the first column name will be all weird.

[Jolanrensen]

Do you have a sample CSV so we can make some tests too?

[janseeger]

Unfortunately none that I can easily share. I'll try to create a small reproducer this evening.

[janseeger]

Here's the CSV File. I noticed that the Column Names are correct when accessed with columnNames() but the generated code does not strip the BOM character.

[Jolanrensen]

Can reproduce, thanks :) Looks like the column name is read incorrectly entirely, since getting by name (without zero width non breaking space character) also breaks.

The BOM character should be skipped if a file starts with it.