topic Korean character is broken when I export the query results in .csv file in Getting Data In

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

yschoi — Wed, 28 May 2014 04:49:13 GMT

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!

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

yschoi — Wed, 28 May 2014 05:10:19 GMT

Is there any other way without Excel Export app?

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

ruman — Wed, 28 May 2014 05:27:33 GMT

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.