Splunk Search
Highlighted

Check the first character of a string with eval case

Communicator

Hi Team,
I want to create a new field REGIONID With following requrirements:-
If (TKT
CREATOR ="IP-Z" OR "DEP-IP-Z")
REGIONID = "IpHW"
Else If (TKT
CREATOR ="IP-Z" OR "DEP-IP-Z")
REGION_ID = "IP-CS"

index="Index1" sourcetype="XXX"| eval REGIONID = case((TKTCREATOR == "IP-Z" OR TKTCREATOR == "DEP-IP-Z"), "IpHW", (TKTCREATOR== "IP-W" OR TKT_CREATOR == "DEP-IP-W"), "IP-CS")

and this is working fine.

Now I would also like to check If First Character of another field "Name" is "X" then REGIONID = "XRegion" (in the same eval case statement). Is there a way to check the first character of a field value and assign other value to the new field REGION_ID.

0 Karma
Highlighted

Re: Check the first character of a string with eval case

Motivator
index="Index1" sourcetype="XXX" 
| eval firstCharOfName=substr(Name,1,1) 
| eval REGION_ID = case((TKT_CREATOR == "IP-Z" OR TKT_CREATOR == "DEP-IP-Z"), "IpHW", (TKT_CREATOR== "IP-W" OR TKT_CREATOR == "DEP-IP-W"), "IP-CS", firstCharOfName=="X", "X_Region")

If you extract the first character of Name using an eval into a field firstCharofName then you should be able to add that to your case.

Highlighted

Re: Check the first character of a string with eval case

SplunkTrust
SplunkTrust

hey Try this

index="Index1" sourcetype="XXX" 
| eval REGION_ID = case((TKT_CREATOR == "IP-Z" OR TKT_CREATOR == "DEP-IP-Z"), "IpHW", (TKT_CREATOR== "IP-W" OR TKT_CREATOR == "DEP-IP-W"), "IP-CS",substr(Name,1,1)="X","X_Region")

let me know if this helps!

View solution in original post

Highlighted

Re: Check the first character of a string with eval case

Communicator

super, thank you 🙂

0 Karma
Highlighted

Re: Check the first character of a string with eval case

Motivator

I didn't think to put the substr right in the case. I like that!

0 Karma