Splunk Search

How to match portion of string between two fields in splunk

obais9346
Engager

Example:

field1=ADOBE INC.

field2=ADOBE SYSTEMS&sep1; INCORPORATED

i want to match this as both fields containing "ADOBE" in string, i am a advanced beginner to splunk 

i have tried below condition in my splunk search but no luck(did not work)

..........| eval results= if(like(field1,"%".field2."%"),"Yes","No")

Please help and it is appreciated.

Thank You:)

Labels (1)
0 Karma

obais9346
Engager

Thanks for making me understand

But my requirement is to match 

field1=ADOBE INC.

field2=ADOBE SYSTEMS&sep1; INCORPORATED

How do i achieve this?

thanks in advance!

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Are you expecting these to fields to appear equal in some way? If so, what criterion do you want to use to say that they are equal? 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

You won't get a match because field2 does not exist in field1, but also field1 doesn't exist in field2, but if field1 was just "ADOBE" it would match

| makeresults
| eval field1="ADOBE"
| eval field2="ADOBE SYSTEMS INCORPORATED"
| eval result=if(like(field2,"%".field1."%"),"Yes","No")
0 Karma
Get Updates on the Splunk Community!

Discover Powerful New Features in Splunk Cloud Platform: Enhanced Analytics, ...

Hey Splunky people! We are excited to share the latest updates in Splunk Cloud Platform 9.3.2408. In this ...

Splunk Classroom Chronicles: Training Tales and Testimonials

Welcome to the "Splunk Classroom Chronicles" series, created to help curious, career-minded learners get ...

Access Tokens Page - New & Improved

Splunk Observability Cloud recently launched an improved design for the access tokens page for better ...