https://community.splunk.com/t5/Splunk-Search/Lookup-with-wildcard-in-data-not-in-lookup-table/m-p/567177#M197646 <P>Hi. I know a lookup file can contain wildcards and use them with the WILDCARD(&lt;field&gt;) setting, but is it possible to do the opposite, where the wildcard is in the dataset, rather then the lookup?</P><P>For more detail:</P><P>I have a lookup file that contains names and some location information, formatted like this:</P><P>lastname, firstname, m [us-us]&nbsp;&nbsp;</P><P>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.&nbsp;</P><P>Is it possible to do wildcard matching to a lookup when the wildcard is in the data set, as opposed to the lookup file?&nbsp; 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?</P><P>| lookup myfile fullname as name&nbsp;</P><P>I appreciate any help. I tried looking around for this, but only found references to the wildcard in the lookup, not in the dataset.</P> Thu, 16 Sep 2021 01:09:42 GMT etoombs 2021-09-16T01:09:42Z https://community.splunk.com/t5/Splunk-Search/Lookup-with-wildcard-in-data-not-in-lookup-table/m-p/567177#M197646 <P>Hi. I know a lookup file can contain wildcards and use them with the WILDCARD(&lt;field&gt;) setting, but is it possible to do the opposite, where the wildcard is in the dataset, rather then the lookup?</P><P>For more detail:</P><P>I have a lookup file that contains names and some location information, formatted like this:</P><P>lastname, firstname, m [us-us]&nbsp;&nbsp;</P><P>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.&nbsp;</P><P>Is it possible to do wildcard matching to a lookup when the wildcard is in the data set, as opposed to the lookup file?&nbsp; 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?</P><P>| lookup myfile fullname as name&nbsp;</P><P>I appreciate any help. I tried looking around for this, but only found references to the wildcard in the lookup, not in the dataset.</P> Thu, 16 Sep 2021 01:09:42 GMT https://community.splunk.com/t5/Splunk-Search/Lookup-with-wildcard-in-data-not-in-lookup-table/m-p/567177#M197646 etoombs 2021-09-16T01:09:42Z