Archive

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
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!