Are you a member of the Splunk Community?
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Extract fields of CSV data source in Upper case
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How have you extracted fields? Do you have control on changing the CSV headers?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
no I do not have control on CSV .
Field extraction was done automatically when I choose sourcetype = CSV
Tech Talk Recap | Mastering Threat Hunting
Observability for AI Applications: Troubleshooting Latency
Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?
