Splunk Search

Want to replace the field value name

ramkyreddy
Explorer
Name sku kit
NAC-D-CDSK-DLS-05.90 NAC-D HJA-JEOE-DNDN-94.4.0


This my data, I want to replace  with NAC-D to ANT-P for multiple values
this is my search query

| eval sku = if(name=="",substr(kit,0,5),substr(name,0,5))
| eval sku=case(sku =="NAC-D","ANT-P ",sku =="DHV-K","ABD-U",true(),sku)



Labels (2)
0 Karma

ramkyreddy
Explorer

thanks,  I got expected  output

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @ramkyreddy ,

good for you, see next time!

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated 😉

gcusello
SplunkTrust
SplunkTrust

Hi @ramkyreddy,

what exactly is your requirement?

<your_search>
| eval sku = if(name="",substr(kit,0,5),substr(name,0,5))
| eval sku=case(sku="NAC-D","ANT-P",sku="DHV-K","ABD-U",true(),sku)

the search should work.

 Ciao.

giuseppe

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...