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!

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...