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…