Encoding while create .CSV file

[Pavel Solopov]

Hi all,

I need your advice.

In my application I create .csv file (semi-comma separated).

If I open this file through "import data from text" in Excel, there correct recognised UTF-8 encoding and all data displayed correctly.

But if I open file by double click, cyrillic text displayed incorrectly.

Is there are any way to encode text where I create file or give some directive to Excel that text in the file encoded by UTF-8?

Thank you in advance.

Pavel.

  

[SteveJG]

Perhaps one of these links will help Pavel :  https://www.google.com/search?q=excell+utf8+encoding&oq=excell+utf8+encoding&aqs=chrome..69i57.12607j0j7&sourceid=chrome&es_sm=93&ie=UTF-8  

Regards,

Steve

[Taifun]

you have to store the file in UTF-8 format, see also here

How to get european or chinese characters from Web ResponseContent

Taifun

[Pavel Solopov]

Hi Taifun,

I create .csv file in my application by File component. And want to open one on a PC.

How can I set encoding for File component?

[Pavel Solopov]

Hi Steve,

for my regret must links are about how make csv from Excel, not about how make csv for Excel.

In one link describe similar issue (http://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically), thera recomended add BOM in begine of the file.

But my Excel ignore it and display BOM as ordinar simbols... 

[Taifun]

I create .csv file in my application by File component. And want to open one on a PC.
How can I set encoding for File component?

this sounds like an Excel issue then

did you try the suggestions in your stackoverflow link?

Taifun 

[Pavel Solopov]

Sory, Taifun, my English not so well. What do you mean "stackoverflow link"?

Pavel

[Taifun]

this is your stackoverflow link http://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically

I do not have Excel, but I tried Libre Office, and as you can see it works fine to import a file (but only if you use the correct encoding in Libre Office)

Taifun

[Pavel Solopov]

No, my Excel don't recognize BOM and display it as content of cell.
But if I open file from Excel by "import from..." encoding and cyrilic recognized correct.
Also if I open file by notepad and save it, after that Excel display cyrilic correct.

[Pavel Solopov]

Continue to last message:
But it is not suitable way. I want open file from e-mail (application send one) without additional operations.

[Pavel Solopov]

I locolise the problem.

Excel correct recognize BOM, but as I understood FILE component don't recognize escape sequence \u or \x, as a resoult when I try to write BOM it writed not like HEX, but like ordinary char.

[Abraham Getzler]

The Web component has a HTML Text Decode block to encode hex,

if you want to try generating an inline BOM.

I don't know if it would survive passage through the File component.

Let us know?

See attached.

ABG

[Pavel Solopov]

Excellent!!!!!

Thank you, Abraham!!!

Such configuration gave needed  me result