Forum Discussion
data validation
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
- Load the CSV file
- Perform the conversion in the menu under "Encoding / Convert to UTF-8 without BOM"
- 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)
NikolinoDE Thank you for assistance, but it's not working. Any way, thanks again...