Splunk Search

How to extract string from lookup field?

nathanluke86
Communicator

Hi,

 

I need to extract a string from a field in a lookup.

need to extract between <query> and <query>  and the field name is "eai:data"

any help would be appreciated.

 

Labels (3)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @nathanluke86,

if you could share some sample of your data I could be more detailed, anyway, please try a regex like this:

| rex field=your_lookup_field "\<query\>(?<eai:data>[^\<]*)"

Ciao.

Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @nathanluke86,

if you could share some sample of your data I could be more detailed, anyway, please try a regex like this:

| rex field=your_lookup_field "\<query\>(?<eai:data>[^\<]*)"

Ciao.

Giuseppe

Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...