PDF Forms | Export/ Restrict other languages

New Here ,
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

96

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Most Valuable Participant ,
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?

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
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!

 

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Most Valuable Participant ,
Aug 21, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
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!

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Most Valuable Participant ,
Aug 21, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
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. 

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Most Valuable Participant ,
Aug 22, 2020

Copy link to clipboard

Copied

Try:

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

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
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. 

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Most Valuable Participant ,
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.

Likes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

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