doesn't handle CSVs with uneven number of columns correctly

[masukomi]

I have a csv with >=4 columns per row. Columns 5+ are all strings in the csv
the 1st 4 columns are handled as expected. the 5th column is titled "Rec", is an int, and contains 1 on all rows.

Neither "Rec" nor the "1" are from the CSV.

if i had to guess Tad is assuming that the number of columns in the first row is going to be the same in all the other rows and then getting confused when it hits more and adding that Rec column... whatever that is.

[ghost]

Rec is the number of records. When you use the Pivot function etc. it is very helpful. That has nothing to do with your columns problem.

I think your problem is just that the first column is interpreted as the header and now you have rows with more columns than the header has. When I open such an example, Tad chrashes with an SQLite error

SQLITE_ERROR: duplicate column name: undefined