Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
A custom script does not read foreign characters found in a tab or comma delimited file
Answer ID 7033 |
Last Review Date 07/22/2019
Why aren't foreign characters in a tab or comma delimited file read by a custom script?
Environment:
Connect PHP API (File Manager, Customer Portal, Process Designer)
Resolution:
If a field in a tab or comma delimited file contains foreign characters, the field must be surrounded by double quotes.
Cause:
PHP's fgetcsv function which is typically used to parse tab or comma delimited files will ignore some UTF-8 characters in a field if they are not preceded by an ASCII character.