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!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...