Splunk Search

Extract fields of CSV data source in Upper case

rashi83
Path Finder

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?

Tags (1)
0 Karma
1 Solution

jnudell_2
Builder

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.

View solution in original post

0 Karma

jnudell_2
Builder

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.

0 Karma

somesoni2
Revered Legend

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

0 Karma

rashi83
Path Finder

no I do not have control on CSV .

Field extraction was done automatically when I choose sourcetype = CSV

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Agent Mode Engaged! Enchaining Agentic Operations with Splunk AI Assistant 2.0

    Are you ready to transform how your team handles complex data requests? We invite you to our upcoming ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...