Skip Navigation
Expand
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.