Splunk downloaded csv is converting special symbols like Ω, µA into different symbols?

[mukka123]

Hello Team,

We have some special symbols which are in our application like Ω, µA etc..

We are able to export data from application successfully and push it to Splunk and able to create report successfully.

In Splunk report we are able to see the symbols properly without any issue but when we download the data into a csv and see the symbols it is converting into different symbols. Can somebody help us how we can solve this

Thanks,

Reddy

[VatsalJagani]

@mukka123 - Are you reading the CSV file in Excel?

If so you need to tell Excel to use UTF-8 encoding - https://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-...

I hope this helps!!! Kindly upvote if it does!!!

[mukka123]

@VatsalJagani Thanks for your reply.

We already tried it what was mentioned below

Like downloading the csv from Splunk and then load it with UTF-8 , it worked but our goal is to downloaded file from splunk itself should have this special symbols without converting them

[VatsalJagani]

@mukka123 - You are not converting the file here, you are reading it the right way.