All Apps and Add-ons

How to create 2 regex to extract the "intranet" and the "output"?

Bradd23
Loves-to-Learn Lots

Hi,  we have some data that contains a hierarchy of folders that we want to extract from the source path, the raw data looks like this : 

source= /usr/local/intranet/areas/ua1/output/MUN

we would like to create 2 regex to extract the "intranet" and the "output"

Can someone please help

Thanks

Labels (1)
Tags (1)
0 Karma

somesoni2
Revered Legend

A similar problem (extracting fields from source) is solved here:

https://community.splunk.com/t5/Splunk-Search/extract-a-field-from-event-source-filename/m-p/36029

Depending upon the order of the words and what part is static, the regex will change accordingly.

e.g. if "intranet" is always the 3rd segment and "output" is 6th, following regex could work:

^\/usr\/local\/(?<fieldName1>[^\/]+)\/([^\/]+\/){2}(?<fieldName2>[^\/]+) in source

 

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Bradd23,

you could use a regex like the following

| rex field=source "^(\/\w+){2}\/(?<field1>\w+)\/(?<field2>\w+)"

that you can test at https://regex101.com/r/zXtNKV/1

Ciao.

Giuseppe

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...