CSV error too many fields in record #1... but different!

So here's a weird one. the "too many fields in record #1" error but there are not too many fields.

One might think there's a hidden carriage return in one field (I've encountered that before) but see here for when I open csv the file in excel, save it, close it, and run the plan again there is no error! I make no change and tadah!

Next time the error happens I'm going to try opening it and NOT save it to see if it still works.

edit: Nope doesn't help (of course) also opening and saving in Notepad++ doesn't have the same effect as saving it in excel (still as a csv) without any changes.

Setting it to "ignore errors" just corrupts my data so that's a nogo.

Any ideas?

Thanks all!

Error Message

Accepted answers

markcurry

Have you tried setting the Delimiters to \0 and increasing the Field Length? Then use the Text to Columns to split the Input.

CSV File.png

All comments

markcurry

Have you tried setting the Delimiters to \0 and increasing the Field Length? Then use the Text to Columns to split the Input.

CSV File.png

ChrisSpr

I had to wait a day for the error to resurface but yes that kinda works. How does one go about getting the column headers corrected then? All the columns are just numbered (or the entire list of label names deliminated by commas for each column. ufdah!) instead of properly named.

I guess I can go manually rename all 49 columns.. ><

Danke.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335