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.

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Vibe-coding, AI, and Splunkcraft: Highlights from the .conf26 Builder Bar

If you stopped by the Builder Bar at .conf26, thank you! This year, we brought ...

Thanks for the Memories: .conf26 Took Learning to New Heights

Thank you, Splunk Community, for making .conf26 in Denver one for the books. From packed Splunk University ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...