WinBatch® Technical Support Forum

All Things WinBatch => WinBatch => Topic started by: 1bosborn on November 19, 2021, 01:40:03 PM

Title: ArrayFileGetCsv error 1808 invalid csv lines
Post by: 1bosborn 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?
Title: Re: ArrayFileGetCsv error 1808 invalid csv lines
Post by: td 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.
Title: Re: ArrayFileGetCsv error 1808 invalid csv lines
Post by: 1bosborn on November 19, 2021, 03:15:22 PM
Thank you so much, as always.