Getting Data In

Eval

Khuzair81
Path Finder

c= US

Language = abcdENGLISH123qw

..... | rex fields=Language "\w{4}(?<myval>)\d{4}"

| eval ans=case(c="US",myval, true(), "NA" ) | table ans, myval, c

Result

ans = NA

myval = English

c = US

 

I want the ans = English

Labels (1)
0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@Khuzair81 

Can you please try this?

YOUR_SEARCH
| rex field=Language "^[a-zA-z]{4}(?<myval>\w+)\d{3}" 
| eval ans=case(c="US",myval, true(), "NA" ) 
| table ans, myval, c

 

My Sample Search :

 

| makeresults 
| eval c="US",Language="abcdENGLISH123qw" 
| rex field=Language "^[a-zA-z]{4}(?<myval>\w+)\d{3}" 
| eval ans=case(c="US",myval, true(), "NA" ) 
| table ans, myval, c


 

Thanks
KV
▄︻̷̿┻̿═━一

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...