Splunk Search

extract the value for the field

hashsplunk
Loves-to-Learn Lots

incoming/d0000c00002/data_reuse/d000/d0000c00002/ar/shared/sdtm/prod/data/idap_20191011/dm.sas7bdat

 

what I need is to extract only d0000c00002 before data _reuse

Labels (1)
0 Karma

hashsplunk
Loves-to-Learn Lots

Sometimes the data looks like below without the prefix incoming 

 

d0000c00004/data_reuse/d000/d0000c00004/ar/shared/adam/prod/data/idap_20191011/adlbh.sas7bdat

i just need to extract before the keyword data_reuse in both cases with and without  incoming 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rex "(?<field>[^\n\/]+)\/data_reuse"
0 Karma

hashsplunk
Loves-to-Learn Lots

Sorry not working

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| makeresults | eval _raw="d0000c00004/data_reuse/d000/d0000c00004/ar/shared/adam/prod/data/idap_20191011/adlbh.sas7bdat"
| rex "(?<field>[^\n\/]+)\/data_reuse"
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rex "^incoming\/(?<field>[^\/]+)"
0 Karma
Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...