Encoding CSV file to UTF-8 with BOM

How To
1

Dear Community,

I need to send data in Korean in a CSV file and Korean characters are not rendered correctly in CSV. I tried to use Tools-Convert the encoding of a text but got no luck as utf8bom is not an available format as output codepage.

I searched a lot on the net but I am now stuck as I cannot find any reliable solution. Some guys propose to add 0xEF and such using text aggregator but there 0xEF is interpreted as a standard string and not as a “prefix” for the following text encoding.

I really have doubt that we cannot do that properly in Make as special characters are everywhere in the non-English world.

Anyone to tell me what I missed and how to handle that so my Korean characters will render correctly in the resulting CSV file?

Thanks a lot.

Best,

T.

4

Hey T,

Maybe you can try with the new Code app and write a short script that does the converting?

5

Hi Stoyan,

I use Make through Celonis so not sure all features are available.

What do you call « the new Code app »?

6

https://www.make.com/en/blog/make-code-app