Splunk Search

change lookup macth_type

jonthanze
Explorer

Hi

I have a list of words in a lookup table and i would like to return the events of a search that match any of the values in the lookup.

So far, nothing really hard to implement in Splunk.

The problem is that some of the values in the lookup are partially to the one in the search
(e.g :the value in my lookup is foo and the one in my search is foobar).


I read this :

http://answers.splunk.com/answers/718/how-are-values-in-lookups-matched

and tried that :

(from transforms.conf)


[sourcetype i am querying]
filename = "lookup table file name"
case_sensitive_match = false
match_type = WILDCARD(field that contains "foobar")



But the entry "foo*" in my lookup did not find it.

Can someone please help me solving this ?

Thanks

0 Karma

Ayn
Legend

With WILDCARD you need to actually put in wildcards in your lookup in order for Splunk to do a wildcard match. So if you want to match the value "foobar" from your results, the value "foo" in the lookup will not match but "foo*" will.

0 Karma

jonthanze
Explorer

Hi

as you can read under in my question , i already altered my lookup to contain the wildcards
but it doesn't work
is there a problem with the definitions in transforms.conf ?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas     Cisco Live 2026 is almost here, and this ...

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Hello Splunkers,   So you searched, “what is the name of the usb key inserted by bob smith?”  Not gonna lie… ...

Automating Threat Operations and Threat Hunting with Recorded Future

    Automating Threat Operations and Threat Hunting with Recorded Future June 29, 2026 | Register   Is your ...