Ignoring a variable number of columns at end of the CSV?

[thedavegray]

Hello

Is there a way of ignoring one or more columns from the end of a CSV?

I have a file that comes from an external source that occasionally has a one or more extra columns (junk values) at the end. I added this to the end of my class definition but I still get an error about bad data and that it can be ignore.

[JoshClose]

Bad data happens with parsing. There is a field with an invalid format. You can try to ignore the bad data by settings BadDataFound = null like you did, but it's possible that could mess up reading the rest of the file.