Forum Discussion

Vlatko1990's avatar
Vlatko1990
Copper Contributor
Nov 06, 2020

data validation

the data that i exported form other program has column with values "8-2271" (the last 4 numbers are different), but in excel show me like date aug.71 in cell, but up in functions show me in format li...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Nov 06, 2020

 If I may add this information to Mr. Sergei Baklan (@Sergei Baklan) statement.

As far as my research is based on statement from Mr. Sergei Baklan ,

Microsoft Excel does not check the character set and instead assumes, without checking, that the content of a CSV file corresponds to a Windows-specific character set (Windows-1252).

As a result, when a CSV file is opened, the content is incorrectly decoded and the special characters are displayed incorrectly.

 

Small and quick solution:

To open a CSV file with Microsoft Excel, which uses UTF-8 as character encoding (standard with Cloudrexx), proceed as follows:

You can convert your CSV file e.g. with the free Notepad

  1.            Load the CSV file
  2.            Perform the conversion in the menu under "Encoding / Convert to UTF-8 without BOM"
  3.            3. Save the CSV file.

    I hope we could help you a bit.

     

    Thank you for your understanding and patience

     

    Nikolino

    I know I don't know anything (Socrates)

     

Vlatko1990

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 06, 2020

NikolinoDE 

Excel, if open csv file directly, converts texts like "11-07" into dates as 07 Nov 2020 (depends on locale) independently on which encoding is used.

Resources