Getting Data In

Korean character is broken when I export the query results in .csv file

Engager

When I export the query results in .csv file using export function, the Korean character is broken.

I found out the Excel Export app in the splunk website.
When I use the Excel Export app, there is no problem.

But the Excel Export app saves query results as .xls file not .csv file.

Please help me to solve this problem.

Thanks in advance!

Tags (2)
0 Karma

Splunk Employee
Splunk Employee

How are you viewing the CSV file? Assuming the output is UTF-8 (which should be the case unless you've instructed Splunk to use a different character set for this source), you might need to tell Excel to use UTF-8 when you open the CSV. http://stackoverflow.com/a/6488070 has some instructions for this.

If you are opening it with another application, make sure that it supports and recognizes the character set that the data is in.

Engager

Is there any other way without Excel Export app?

0 Karma