CSV Export Error

I am exporting data to a csv file. After export, the data in the csv file includes extra spaces that were not present in the original data. For example, the string CONAN is exported as C O N A N . Anybody have suggestions on where to begin troubleshooting?

Probably hidden unicode stuff. You propably copy pasted this CONAN from somwwhre, delete it completly, and rewrite it key by key and see if there's still the problem

1 Like

I’m importing an invoice text file and then performing the export to the csv. I’ve identified four lines in the invoice text file that are causing the issue. When I exclude these lines from the import everything works fine. It’s possible these four lines have hidden Unicode characters. Oddly, these four lines are causing the same error in all the other lines in the csv file.

I'd suggest taking a look at the encoding used for the export. If it is set to UTF-16, I'd try switching that to UTF-8, and see if anything changes in the output.

It's not that UTF-16 is the wrong choice, but depending on what UTF-16 output is read by, and if it is misinterpreted as another charset encoding, the output could appear to have extra chars in between other chars. If so, the two approaches to working around this that I know of are:

  1. Use something else to read the data, which will, for sure, treat it as UTF-16.

  2. Try using UTF-8 to output, instead.

HTH, and, if you are already exporting as UTF-8, then sorry that this probably won't be of much help.

I’m exporting to CSV, and then importing back into FMP. I’ll make sure both the export and import are using UTF-8, thanks.

1 Like