topic Re: Why is CSV data showing up as hexadecimal? in Splunk Search

Why is CSV data showing up as hexadecimal?

jordanking1992 — Wed, 31 Jul 2019 14:34:25 GMT

Please see the attached screenshot.

I have a uploaded CSV with valid data but when I upload the CSV, the GUI displays all of my column/rows as hex code.
Haven't had an issue with any other CSV uploads.

Re: Why is CSV data showing up as hexadecimal?

gcusello — Wed, 31 Jul 2019 14:42:07 GMT

Hi jordanking1992,
you have to find the correct charset, the only way is to ingest your csv file using the guided ingestion [Settings -- Data Inputs -- Files and Directories -- New Local File & Directory].
In this way you can try different CHARSETs and find the correct one.
Anyway, where does your csv come from?

Bye.
Giuseppe

Re: Why is CSV data showing up as hexadecimal?

jordanking1992 — Wed, 31 Jul 2019 15:01:24 GMT

That was the issue. But when i change it to AUTO, the body of the CSV is now readable but the columns are still in hex. Its coming from a windows server and i believe the csv is generated by a powershell script.

Re: Why is CSV data showing up as hexadecimal?

rashi83 — Thu, 18 Jun 2020 19:43:36 GMT

IS this resolved for you? I am also facing similar issue . Any insights will be helpful.

CHARSET is already AUTO but still data is showing as hexadecimal .

Re: Why is CSV data showing up as hexadecimal?

Charan — Fri, 09 Oct 2020 16:06:33 GMT

Did you guys found any solution, even I am facing the same issue please let me know if there is any solution