Skip to main content
C
Charmaine3553936377s9
Participant
February 19, 2024
Question

Import Chinese character from Unicode Text file into Adobe Forms

  • February 19, 2024
  • 1 reply
  • 2793 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
    Thom ParkerCommunity 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
    C
    Charmaine3553936377s9Author
    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?

    try67
    Community Expert
    try67Community Expert
    Community Expert
    February 19, 2024

    Hi Thom, I need to use the import data to allow me import my data externally into Forms. If there is any other ways, can you please show me?

    In order to use the Import Data option, there are only a few file types that are supported: .fdf, .xfdf,.xml, .xfd, ,txt

    I tried the .xml format before, converted to utf-16, still now working. Nothing happens after importing the data. 


    I think you need to use XFDF for it to work. If you want it to work with a text file then you must use a script, which will allow you to specify the encoding of the text stream.

     

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