ArrayFileGetCsv error 1808 invalid csv lines

Started by 1bosborn, November 19, 2021, 01:40:03 PM

Previous topic - Next topic

1bosborn

Greetings wise ones. I have a script trying to open a tab delimited file using inventoryarray = ArrayFileGetCsv("inv_uv_master_store1.tsv",1,@Tab) and it gives me an error 1808: File contains invalid CSV line(s). As I said, it is tab delimited, not comma and it opens fine in Excel, LibreOffice and notepad++. I can't see anything visually that looks like an anomaly but who knows what could be skulking around in the non-printable character world.  Any suggestions on how to identify the culprit?

td

That error produces the line number of the offending line in the "More error info" box displayed when you click the same-named button on the error message box. That would be a good place to start. You should also make sure your csv file is ANSI and not UTF-16 Unicode.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

1bosborn