Splunk Search

Lookup with wildcard in data, not in lookup table?

etoombs
Path Finder

Hi. I know a lookup file can contain wildcards and use them with the WILDCARD(<field>) setting, but is it possible to do the opposite, where the wildcard is in the dataset, rather then the lookup?

For more detail:

I have a lookup file that contains names and some location information, formatted like this:

lastname, firstname, m [us-us]  

I have some source data that contains names, without the middle initial or the location data. I can manipulate it to get it into lastname, firstname format. 

Is it possible to do wildcard matching to a lookup when the wildcard is in the data set, as opposed to the lookup file?  So, if my data has a field called name as Doe, John* and the lookup file has fullname: Doe, John M [us-us], it would be a match?

| lookup myfile fullname as name 

I appreciate any help. I tried looking around for this, but only found references to the wildcard in the lookup, not in the dataset.

Labels (1)
Tags (2)
0 Karma
Get Updates on the Splunk Community!

Get Operational Insights Quickly with Natural Language on the Splunk Platform

In today’s fast-paced digital world, turning data into actionable insights is essential for success. With ...

What’s New in Splunk Observability Cloud – June 2025

What’s New in Splunk Observability Cloud – June 2025 We are excited to announce the latest enhancements to ...

Almost Too Eventful Assurance: Part 2

Work While You SleepBefore you can rely on any autonomous remediation measures, you need to close the loop ...