Splunk Search

Eval and If else value return or else null

Splunk_rocks
Path Finder

Hello Splunkers,

Im constructing Eval field " user1" actually user field contain 5 digit number so i have to construct a EVAL field like

index= XXX| "xxxxx" |eval user1 = if((user_pin > 0), "user_pin", "Unknown") | table user1 user_pin

If "user1" field is 7 digit then in just return actual 7 digit number or else if it is string just say "null value"

EVAL-user = if((user1== 5 digit number ) "reportactull number ", "report null value ")

Please let me know

Tags (2)
0 Karma
1 Solution

woodcock
Esteemed Legend

You say both 7-digit and 5-digit but I am assuming that you mean the latter, so like this:

EVAL-user=if(match(user1, "^\d{5}$"), user1, "null value")

View solution in original post

0 Karma

woodcock
Esteemed Legend

You say both 7-digit and 5-digit but I am assuming that you mean the latter, so like this:

EVAL-user=if(match(user1, "^\d{5}$"), user1, "null value")
0 Karma

Splunk_rocks
Path Finder

Thanks that worked ..if i want to capture word or digit In case 5 -7 digit number or 5-8 word id.

0 Karma

Splunk_rocks
Path Finder

I need to match below to construct eval field.

user
X234578
wertyui
kxtur
lytue23

0 Karma

woodcock
Esteemed Legend

Change d{5} to d{5-8} or similar.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...