Convert CSV files use "us-ascii" encoding which contain Chinese characters, however the result contain garbled

[Lori (Li)]

Description:
A: I have Excel(xlsx) contain remark column, which contain Chinese characters
B: I read excel output as datatable
C: write CSV file use “us-ascii” (must use this encoding) encoding without header
D: Open CSV file find it contain garbled
F: After that, I should open csv file use “UltraEdit32”, If I use other encoding, when open, still have garbled, I posted it below.
abc.xlsx (8.3 KB)

Excel:

Convert CSV file:
-8

CSV(Encoding with “UTF-8”), use “UltraEdit32” open:

Thanks in advance for you help!

[Nithinkrishna]

Hey @Lori

Kindly try the below encoding options,

Ref - https://docs.uipath.com/activities/docs/supported-character-encoding

Thanks
#nK

[Lori (Li)]

@Nithinkrishna
I try gb231 and big5, it’s still have garbled。

Remark: I had edit my post, explain why I have to use “us-ascii” encoding.

[Yoichi]

Hi,

@Lori

C: write CSV file use “us-ascii” (must use this encoding) encoding without header

if it’s encoded as us-ascii by WriteCSV activity, all the Chinese characters is converted to 0x3F(“?”) as the following.

So, we cannot recover it to original character.
Can you try to use “UTF-8” encoding and check it using Notepad.exe?

Regards,