Splunk Search

inputlookup format to insert wildcard * is it possible?

r999
Path Finder

inputlookup like:

user       mailbox
smithj     john smith
bloggsj    joe bloggs

search string:

| inputlookup usermailbox.csv | fields search user mailbox | format "(" "(" "AND" ")" "OR" ")"]

returns

( ( user="smithj" AND mailbox="john smith" ) OR ( user="bloggsj" AND mailbox="joe bloggs") OR...

what i want is to return

( ( user="*smithj*" AND mailbox="*john smith*" ) OR ( user="*bloggsj*" AND mailbox="*joe bloggs*") OR...

Current workaround is to put the wildcards * in the csv values like so but this is a pain

user       mailbox
*smithj*   *john smith*
*bloggsj*  *joe bloggs*

Drainy
Champion

You could use eval to add them in manually at search time;

| eval user="*".user."*"

0 Karma

the_wolverine
Champion

No, unfortunately that doesn't work.

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 ...