ACS: Random characters appear in column definitions on file upload

Description description

Environment
Adobe Campaign Standard

Issue
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:

  1. Use a workflow–Load file activity.
    Have a CSV file with at least one column with a header, let’s say: “Email.”
  2. Select the file within the Load file activity to import the file.
  3. Go to the File structure tab after a successful import.

When you refresh to detect a new column, you will see extra characters with the “Email” header.
This can also be seen in Column definition.

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.

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f