Getting Data In

CSV File Issues

cesardavila
New Member

Hello,
I am having issues with csv files imported from an S3 bucket. The files get imported and indexed fine however what I get when i try to do a search on what has been indexed is something like this:

\x95\x90@\x12\xb1\xe4;g.\xa6\xa3\xfd\x99\xdf\x88I\xc4c\x08\xdb\x03\x00\x00\

Is there something im missing that prevents the simple csv file from being read properly?
Thanks for your help.
Cesar

Tags (1)
0 Karma

dart
Splunk Employee
Splunk Employee

Hi Cesar,

Looks like you might be character encoding issues - can you try manually specifying a character set?

dart

0 Karma

cesardavila
New Member

Hey, Thanks for the suggestion.
I forced the character set utc-8 but still getting the same result. Any other ideas? It happens with .csv files as well as .csv.zip.
Thanks again for your help.

0 Karma

snowmizer
Communicator

CSV files may need to be UTF-16LE.

Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...