Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Special characters in Excel are parsed incorrectly



Special characters in Excel are parsed incorrectly despite uploading the CSV files in the application. As a result, '?' symbols display instead of special characters in the application.

Error Messages

Not Applicable

Steps to Reproduce

Upload any CSV file to the Binary file.

Root Cause

An issue in the custom application code or rules.
The CSV file and the JVM are not encoded to UTF-8. Hence, the special characters are not recognized since they have ANSI encoding.
ANSI supports only a few characters (such as '#', '$', '%', '*', and ',') and does not recognize the remaining characters (such as, 'á', 'é', 'ó', and 'ú'). Hence, the special characters display as '?' symbols.


Perform the following local-change to encode the JVM:

Add the below line in a standalone.conf file if the server is JBOSS. For a Tomcat server, add the line of code in the setenv.bat file.

JAVA_OPTS=%JAVA_OPTS% -Dfile.encoding=UTF8

For CSV file encoding, refer to the video in:

Published April 10, 2020 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us