Splunk Search

Extract Part of Field

IRHM73
Motivator

Hi, I wonder whether someone could help me please.

I'm trying to extract a particular value from a field which is "file-upload-ready". I can manage to exclude the value but not to extract it.

This is and example of the data string:

/country-private/file-upload-ready/1d555d59-9b5f-4877-bc76-2597142e1964/9011be92-6a1b-46a6-9e56-48dfdbf36c24

Many thanks and kind regards

Chris

Tags (2)
0 Karma
1 Solution

koshyk
Super Champion

hi,
Can you please try (assuming second block in your data is what you want)

|makeresults | eval myString="/country-private/file-upload-ready/1d555d59-9b5f-4877-bc76-2597142e1964/9011be92-6a1b-46a6-9e56-48dfdbf36c24"| rex field=myString "\/.+?\/(?<fileStatus>.+?)\/"

https://regex101.com/r/CvfqNH/1

View solution in original post

0 Karma

koshyk
Super Champion

hi,
Can you please try (assuming second block in your data is what you want)

|makeresults | eval myString="/country-private/file-upload-ready/1d555d59-9b5f-4877-bc76-2597142e1964/9011be92-6a1b-46a6-9e56-48dfdbf36c24"| rex field=myString "\/.+?\/(?<fileStatus>.+?)\/"

https://regex101.com/r/CvfqNH/1

0 Karma

IRHM73
Motivator

Many thanks @koshyk.

Regards

Chris

0 Karma

kunalmao
Communicator

you can do it by using rex command,

search .... | rex field=your_field "\/(?\w+-\w+)\/"

just verify the reg ex once.

0 Karma

IRHM73
Motivator

Hi @kunalmaom thank you for this, but unfortunately this doesn't extract any data.

Many thanks and kind regards

Chris

0 Karma

kunalmao
Communicator

obviously it won't , the regex is not correct 😛

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