Showing unknown characters after exporting in CSV

Question

0.00/5 (No votes)

See more:

on portal data showing

CHRIS MORRIS˜

but after Exporting data into CSV It showing like

CHRIS MORRISËœ

apart from that if exporting into excel data exports as same as on portal.

Thanks in advance

What I have tried:

Using ExtJs 2.3 and C#.
What I have to do for export correct data as same as showing on portal.

Posted 25-Jul-18 19:51pm

arvindcis

Updated 25-Jul-18 21:35pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Answer 1 · 2018-07-25T21:35:00

It depends on the character encoding used by your CSV generator and the tool used to display the CSV file content which - in your case - probably did not detect or support the encoding of the file.

The ANSI (Windows 1252) characters "Ëœ" have the hex codes CB 9C which is the UTF-8 sequence for the ~ character (Unicode code point U+02DC).

So it looks like your CSV generator creates an UTF-8 encoded file (which is common) but your "tool" to view the file content assumes ANSI encoding.

There is nothing to do if everything is working as expected. To view the content correctly, open the file with an editor that is able to detect the UTF-8 encoding or provides an option to specify the encoding. An example is the Notepad++ editor (that is not the Windows Notepad).