Getting Data In

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

yschoi
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

ruman
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.

yschoi
Engager

Is there any other way without Excel Export app?

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...