How can I append CSV with its encoding




I have a scenario to merge loads of csv files into one so I’ve tried with [Read CSV] and [Write CSV] activities with encoding “shift-jis.” (Yes, it’s Japanese)

The first file creates a new file with its set encoding and the output is as expected but from the second file which are being appended to the the new file are somehow garbled.
(If I write it out to the output panel, it displays properly tho’.)

Does anyone know how to deal with this issue?

Dealing it with [Read Text File] and [Append Line] works beautifully although I still have to remove its header row by invoking methods like String.IndexOf and String.Substring but this also has an issue that huge csv file creating a long string occurs an exception and crashes the program in the middle of the execution…

Hi, Issue retrieving information from an API, while using HTTP Request Activity of UiPath Studio; when the response has a JSON result that is huge. (Eg: Retrieving 500 items as a json string

I encounter the same problem.
I need to make csv in shift-jis but “Append to CSV” method does not work with shift-jis encoding.

I found that the proper encoding name is “shift_jis” according to this page

but still it doen’t work.

What should I do?