Expand my Community achievements bar.

SOLVED

Handling Special Characters in AEP

Avatar

Level 3

Hello, I have a bit of an urgent ask. 


We're ingesting data into AEP using a csv file, and some values in the csv files are in foreign languages that have special characters (e.g. é or ô). When this data is ingested in AEP the special character is replaced with 

 

How can I ingest data in AEP, such that the special characters don't get replaced. The data type for all these fields is string. 

 

Thanks!

1 Accepted Solution

Avatar

Correct answer by
Adobe Champion

Hi @trojan_horse ,


To sort out the special character issue in your CSV files when uploading to AEP, make sure you save your file as 'CSV UTF-8' instead of the usual comma-separated format. This should prevent those � symbols from showing up in your data.

Bhoomika_S_0-1715316383912.png

 






View solution in original post

1 Reply

Avatar

Correct answer by
Adobe Champion

Hi @trojan_horse ,


To sort out the special character issue in your CSV files when uploading to AEP, make sure you save your file as 'CSV UTF-8' instead of the usual comma-separated format. This should prevent those � symbols from showing up in your data.

Bhoomika_S_0-1715316383912.png