Splunk Enterprise Security

How To rename the field value name from the output.

hrs2019
Path Finder

Hi
I want to rename output field value name

Week1
1. Systems ops 12.1 to ops
2 .Systems dev 12.1 to dev

Below is the diagram for more info.
alt text

0 Karma
1 Solution

kamlesh_vaghela
SplunkTrust
SplunkTrust

@hrs2019
You can use replace also.

https://docs.splunk.com/Documentation/SplunkCloud/8.0.1/SearchReference/Replace

| makeresults 
| eval Week1 ="Systems ops 12.1", "Number of tickets"=20 
| append 
    [| makeresults 
    | eval Week1 ="Systems dev 12.1", "Number of tickets"=15] 
| replace "Systems * 12.1" with "*" in Week1 | eval Week1=upper(Week1)
 | table Week1,"Number of tickets"

View solution in original post

to4kawa
Ultra Champion
| makeresults 
| eval Week1 ="Systems ops 12.1", "Number of tickets"=20 
| appendpipe 
    [| eval Week1 ="Systems dev 12.1", "Number of tickets"=15] 
| eval Week1=Upper(mvindex(split(Week1," "),1)) 
| table Week1,"Number of tickets"

Hi, @hrs2019
This is shortest and REGEX-free.

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@hrs2019
You can use replace also.

https://docs.splunk.com/Documentation/SplunkCloud/8.0.1/SearchReference/Replace

| makeresults 
| eval Week1 ="Systems ops 12.1", "Number of tickets"=20 
| append 
    [| makeresults 
    | eval Week1 ="Systems dev 12.1", "Number of tickets"=15] 
| replace "Systems * 12.1" with "*" in Week1 | eval Week1=upper(Week1)
 | table Week1,"Number of tickets"

vnravikumar
Champion

Hi

Check this

| makeresults 
| eval Week1 ="Systems ops 12.1", "Number of tickets"=20
| append
    [| makeresults 
| eval Week1 ="Systems dev 12.1", "Number of tickets"=15] 
| eval Week1=case(Week1="Systems ops 12.1","OPS",Week1="Systems dev 12.1","Dev",1=1,Week1) 
| table Week1,"Number of tickets"
0 Karma
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.


Introducing Unified TDIR with the New Enterprise Security 8.2

Read the blog
Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Your Voice Matters! Help Us Shape the New Splunk Lantern Experience

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Building Momentum: Splunk Developer Program at .conf25

At Splunk, developers are at the heart of innovation. That’s why this year at .conf25, we officially launched ...