topic Re: Extract fields of CSV data source in Upper case in Splunk Search

Extract fields of CSV data source in Upper case

rashi83 — Mon, 10 Jun 2019 20:19:56 GMT

I have a CSV file with region , status , hostname as Columns - field extraction works and gives them as region , status and hostname. Instead I want extraction to work like "Region " "Hostname " Status".

Is there any setting in source type advance to achieve this?

Re: Extract fields of CSV data source in Upper case

somesoni2 — Mon, 10 Jun 2019 20:23:50 GMT

How have you extracted fields? Do you have control on changing the CSV headers?

Re: Extract fields of CSV data source in Upper case

rashi83 — Mon, 10 Jun 2019 20:41:04 GMT

no I do not have control on CSV .

Field extraction was done automatically when I choose sourcetype = CSV

Re: Extract fields of CSV data source in Upper case

jnudell_2 — Mon, 10 Jun 2019 22:10:18 GMT

Hi Rashi83,

I think it would help if you told us why you want to have the field names from the CSV in proper case. In the end, it's not really going to matter, because you can always rename the fields at search time: | rename region as Region, status as Status, hostname as Hostname

If you're only concerned about how it will appear in search results or a report, then use rename at search time.