313
Views
3
Comments
Solved
[CSVUtil] Special characters from CSV file such as ñ
Question
csvutil
Service icon
Forge asset by Wei Zhu

Hello good day,

It seems that the LoadCSV2RecordList is giving me "?" instead of "ñ". Is there something I need to tweak or adjust to get my desired output?


Thank you and best regards,

Joshua


2021-06-21 12-37-59
Wei Zhu
Solution

Hi Joshua


You'd better confirm the encode of you CSV file.

It seems it is not utf-8. maybe it is iso-8859-1 or something else.

As Pedro said, you can specify it via Encode parameter.


Following is the Encode you can specify

https://docs.microsoft.com/en-us/dotnet/api/system.text.encodinginfo.getencoding?view=netframework-4.8


Regards

Wei


2022-07-12 16-41-57
Pedro Costa

Hi Joshua,


Have you verified the encoding type of your file (ANSI, UTF-8, ...)?

If your encoding type is different of the Default Value of the configuration (UTF-8), this kind of problem may occur.

You can change this value in the configuration structure received by the action. Or change the encoding type directly in your file.


Regards

2021-06-21 12-37-59
Wei Zhu
Solution

Hi Joshua


You'd better confirm the encode of you CSV file.

It seems it is not utf-8. maybe it is iso-8859-1 or something else.

As Pedro said, you can specify it via Encode parameter.


Following is the Encode you can specify

https://docs.microsoft.com/en-us/dotnet/api/system.text.encodinginfo.getencoding?view=netframework-4.8


Regards

Wei


UserImage.jpg
Joshua Emmanuel Pechuela

Thank you for your quick response. I've applied the string "iso-8859-1" the the Encode Parameter. 

God bless!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.