ACS: Random characters appear in column definitions on file upload
Explore how to solve the Adobe Campaign Standard issue where extra characters appear with the email header.
Description description
Environment
- Adobe Campaign Standard
Issue/Symptoms
When a file is uploaded on the Load File activity, when you refresh to detect a new column, extra characters appear with the “Email” header.
This can also be seen in Column Definition.
The ID will result with an i_Email instead of Email.
Steps to reproduce the issue:
- Use a workflow
>Load activity.
Have a CSV file with at least one column with a header, (Example: “Email”) - Select the file within the Load activity to import the file.
- Go to the File Structure tab after a successful import.
Expected Results:
No extra characters appear with the “Email” header.
Column Definition is normal.
The ID will result with “Email”.
Actual Results:
Extra characters appear with the “Email” header.
This can also be seen in Column Definition.
The ID will result with an “i_Email” instead of “Email”.
Resolution resolution
Cause
The issue is related to the file encoding.
When files are saved with the UTF-8-BOM encoding, the BOM characters (EF BB BF) are added at the beginning of the file.