• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

PDF Forms | Export/ Restrict other languages

New Here ,
Aug 20, 2020 Aug 20, 2020

Copy link to clipboard

Copied

Hi,

 

How can I restrict/ limit the languages ( e.g Japanese/ Chinese/ etc) used for input in the Adobe Forms.

 

Also, I can export data to Excel only in English and not in other languages.

 

Are there any ways to solve these 2 issues? Thank you.

 

Best,

TOPICS
How to , PDF forms

Views

516

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 20, 2020 Aug 20, 2020

Copy link to clipboard

Copied

- You can use a custom validation script to only accept specific characters, according to their unicode value.

- To what format are you exporting the form data?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 20, 2020 Aug 20, 2020

Copy link to clipboard

Copied

Hi Try67,

 

- I tried it with English, but didn't work for Japanese/ Chinese.

 

- I'm exporting it to CSV from 'Manage Form Data' > 'Merge Data Files into Spreadsheet. It only shows data in English but not Japanese/ Chinese.

 

Thanks!

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 21, 2020 Aug 21, 2020

Copy link to clipboard

Copied

Try the Export Form Data command, to either TXT or XML.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 21, 2020 Aug 21, 2020

Copy link to clipboard

Copied

Try the Export Form Data command, to either TXT or XML.

<< Just tried it, only showing data that was entered in English only. The ones in JP/CN are showing '........' only

 

 

I can also restrict English input with the following script:

if (/[a-z]/gi.test(event.value)) {

    app.alert("Error! This field may not contain any English letters.");

    event.rc = false;

}

 

but how can I change it to JP/CN?

 

Thanks!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 21, 2020 Aug 21, 2020

Copy link to clipboard

Copied

First step would be to find out the unicode codes for the charaters in both languages.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 22, 2020 Aug 22, 2020

Copy link to clipboard

Copied

Finally got that solved. Thank you!

 

But I still have problem exporting the input data to Chinese/ Japanese. It shows English only and Chinese/ Japanese are replaced by dots only. 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 22, 2020 Aug 22, 2020

Copy link to clipboard

Copied

Try:

if (/[\u4E00-\u9FFF]/.test(event.value)) {

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 22, 2020 Aug 22, 2020

Copy link to clipboard

Copied

Finally got that solved. Thank you!

 

But I still have problem exporting the input data to Chinese/ Japanese. It shows English only and Chinese/ Japanese are replaced by dots only. 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 22, 2020 Aug 22, 2020

Copy link to clipboard

Copied

It might be necessary to do it with a script, as it can set the encoding of the file it generates explicitly.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 26, 2020 Dec 26, 2020

Copy link to clipboard

Copied

LATEST

Is your question "But I still have problem exporting the input data to Chinese/ Japanese. It shows English only and Chinese/ Japanese are replaced by dots only." got solved.

 

I also have the same issue but really can't find a solution.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines