Symptom:

From the Java web Report, You export to CSV . The Exported file contains special/different characters in between the text

Steps:

  1. Execute the Query/Template in the Java Portal
  2. Click on Export to CSV and open the CSV file ,you see the special characters which are not recognized, different language or symbols in between the text  

Causes:

Excel automatically uses the data format ANSI to open files. The server creates the CSV file with the data format UTF-8 if it uses Unicode.

Solution:

To open the CSV file, always use the Excel import wizard and specify UTF-8 or UTF-16 as the data format.

How to do this ?

1. Open a new Instance of Excel.

2. Click on Data:

Pic 11.PNG

3. Next Select “From Text”

4. Next Select the .CSV file from file system:

Pic 12.PNG

5. Select “UTF-8” as the encoding:

Pic 13.PNG

6. Click next and select the relevant separators:

Pic 14.PNG

7. Click on Finish

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply