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,
M
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?
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!
Copy link to clipboard
Copied
Try the Export Form Data command, to either TXT or XML.
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!
Copy link to clipboard
Copied
First step would be to find out the unicode codes for the charaters in both languages.
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.
Copy link to clipboard
Copied
Try:
if (/[\u4E00-\u9FFF]/.test(event.value)) {
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.
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.
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.