Author Topic: ArrayFileGetCsv error 1808 invalid csv lines  (Read 246 times)

1bosborn

  • Newbie
  • *
  • Posts: 14
ArrayFileGetCsv error 1808 invalid csv lines
« on: November 19, 2021, 01:40:03 pm »
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

  • Tech Support
  • *****
  • Posts: 4064
    • WinBatch
Re: ArrayFileGetCsv error 1808 invalid csv lines
« Reply #1 on: November 19, 2021, 02:15:26 pm »
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

  • Newbie
  • *
  • Posts: 14
Re: ArrayFileGetCsv error 1808 invalid csv lines
« Reply #2 on: November 19, 2021, 03:15:22 pm »
Thank you so much, as always.