Cant ingest csv with £ sign, changes to \XA

[rossparfect]

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

[dkeck]

HI,

maybe this provides you with a suitable solution?

https://answers.splunk.com/answers/499555/how-to-parse-the-british-pound-sign-for-currency-f.html

[rossparfect]

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,