Dataset: import csv file doesn't read the character

nfraternali
New Contributor
New Contributor

Hi, 

I'm trying to create a new dataset importing a csv file with the characters but when i click on dataset preview it doesn't show the special character, what's the problem? can you help me? Thank you

nfraternali_1-1682063305027.pngnfraternali_2-1682063392775.pngnfraternali_3-1682063488878.png

I save the csv file with CSV(Comma Delimited)(*.csv).

 

4 REPLIES 4

sahil
Saviynt Employee
Saviynt Employee

Can you share the csv file you are using.


Regards,
Sahil

rushikeshvartak
All-Star
All-Star

It seems special characters are not supported in dataset import

sahil
Saviynt Employee
Saviynt Employee

@nfraternali Can you share the csv once. I tested with Á and was able to preview and upload as well.

sahil_0-1682434233784.png

 


Regards,
Sahil

alanbixby
New Contributor III
New Contributor III

I believe this is an encoding issue; make sure you are using UTF-8 encoding.

It may be beneficial to make the CSV in Notepad instead of Excel, as that'll add a "Encoding" option to the bottom right next to the "Save" button. When I try creating this in Excel, it's defaulting to ANSI encoding.

You can also try using our diacritics conversion dataset as attached, it's adopted from Oracle's mapping and adds & -> and: