Skip to main content
K
K3JAE
Participant
March 10, 2020
Question

export data as UTF-8 csv

  • March 10, 2020
  • 1 reply
  • 1433 views

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.

      This topic has been closed for replies.

      1 reply

      try67
      Community Expert
      try67Community Expert
      Community Expert
      March 10, 2020

      Doing that would require exporting the data using a script.

      K
      K3JAEAuthor
      Participant
      March 10, 2020

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

      try67
      Community Expert
      try67Community Expert
      Community Expert
      March 10, 2020

      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].

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices