Skip to main content
Participant
February 19, 2024
Question

Import Chinese character from Unicode Text file into Adobe Forms

  • February 19, 2024
  • 1 reply
  • 2804 views

I tried to import data from Excel that is exported as Text(Text Delimited) file which includes Chinese characters into Adobe Form, but those chinese Character won't be able to show up propertly in the form. 

However, when I tried to type some chinese character for testing, it works propertly. 

Could any experts help me out here since I had tried to read through so many workaround methods that I red online but still couldn't get it work?

Many Thanks!!!

This topic has been closed for replies.

1 reply

Thom Parker
Community Expert
Community Expert
February 19, 2024

Chineses characters are coded as 16bit values, so the text file must be exported from Excel in utf-16 format. 

You should be able to open it in a code editor such as Notepad++ to check the format. 

 

 

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
Participant
February 19, 2024

Hi Thom, thanks for your reply. I tried to convert it to utf-16 format and re-imported again, then I got the error saying 'Could not load data from the text file'. Is that because Adobe cannot import utf-16 format text file?

Thom Parker
Community Expert
Community Expert
February 19, 2024

I have not tried it myself, at least not using the import data option. But, Acrobat works just fine with UTF-16, so I would think it would load a text file just fine.  However, there could be a problem with the byte order markers. Were there any options for the export from Excel? 

 

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often