export data as UTF-8 csv

[K3JAE]

I have a form that once completed is EXPORTED to a CSV file via the 'Merge Data files into a spreadsheet' option.

This works fine for importing into my program (VB based) unless I have an 'oddball' character such as the degree ( '°' (ALT-0176)) symbol. This imports as a � (Black triangle with Question mark). It appears to export properly into the spreadsheet (meaning it shows the ALT-0176 '°') properly but when using that generated excel spreadsheet and importing into my program it blows up.

Currently I am forced to then open the CSV file in Excel then re-save it as a 'TRUE' UTF-8 csv. This then results in a perfectly imported CSV into my program. 

I need the form to export from Acrobat (latest version) as a true UTF-8 csv file for importing into my program, thus eliminating the need for the extra step of opening the CSV in Excel and re-saving as a true UTF-8 csv.

[try67]

Doing that would require exporting the data using a script.

[K3JAE]

OK, then is there a script that can be used? This is above my paygrade.

[try67]

If you're interested in hiring a professional to write it for you I'm happy to do it. You can contact me via [try6767 at gmail.com].

[K3JAE]

Yeah... no. I'll continue doing things as I do now. Thanks but no thanks. I thought there would be a simple script I can get and adapt. If there are none then I'll just continue doing the extra step. It only takes an extra minute out of my day.