Splunk Search

Cant ingest csv with £ sign, changes to \XA

rossparfect
Path Finder

Good evening one and all,

I have CSV files that have monetary values in them, however when they are ingested into splunk I get the following

\xA123,345

Is there away to resolve this pre indexing ,

Thanks

Ross

Tags (1)
0 Karma

dkeck
Influencer
0 Karma

rossparfect
Path Finder

Thanks Dkeck , Id looked at this option, however it was more before the data got indexed rather than after,
However turns out the office 2016 now has a UTF-8 option which recognizes the £ sign, albeit puts it as a character rather than an integer, but it does mean I may be able to regex out the number in a transforms,

Thanks Though,

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...