Getting Data In

How do I modify my rex command to remove directory location from path?

jeradb
Explorer

Here is my current rex command - 

 

 

EventCode=1004
| rex field=_raw "Files: (?<Media_Source>.+?\.txt)" 
| table Media_Source

 

 

 

My source data looks like this -

 

 

Files: C:\ProgramData\Roxio Log Files\Test.test_user_20240305122549.txt SHA1: 73b710056457bd9bda5fee22bb2a2ada8aa9f3e0

 

 

 

My current rex result is -  C:\ProgramData\Roxio Log Files\Test.test_user_20240305122549.txt

How do I make it - Test.test_user_20240305122549.txt

Im trying to drop - C:\ProgramData\Roxio Log Files\

Labels (2)
0 Karma
1 Solution

yuanliu
SplunkTrust
SplunkTrust

This question better belongs to Splunk Search.  Anyway, let me generalize your ask: You want the last part of the file path (which is usually file name).  You can use regex.  But a more semantic and potentially cheaper solution is to use split and mvindex.

EventCode=1004
| rex field=_raw "Files: (?<Media_Source>.+?\.txt)"
| table Media_Source
| eval Filename = mvindex(split(Media_Source, "\"), -1)

If you really want to use regex, you can do

EventCode=1004
| rex field=_raw "Files: .+?\\(?<Media_Source>[^\\]+\.txt)" 
| table Media_Source

Hope this helps.

View solution in original post

Tags (2)
0 Karma

yuanliu
SplunkTrust
SplunkTrust

This question better belongs to Splunk Search.  Anyway, let me generalize your ask: You want the last part of the file path (which is usually file name).  You can use regex.  But a more semantic and potentially cheaper solution is to use split and mvindex.

EventCode=1004
| rex field=_raw "Files: (?<Media_Source>.+?\.txt)"
| table Media_Source
| eval Filename = mvindex(split(Media_Source, "\"), -1)

If you really want to use regex, you can do

EventCode=1004
| rex field=_raw "Files: .+?\\(?<Media_Source>[^\\]+\.txt)" 
| table Media_Source

Hope this helps.

Tags (2)
0 Karma
Get Updates on the Splunk Community!

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more with ITSI’s ...

Accelerate Service Onboarding, Decomposition, Troubleshooting - and more! Faster Time to ValueManaging and ...

New Release | Splunk Enterprise 9.3

Admins and Analyst can benefit from:  Seamlessly route data to your local file system to save on storage ...

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...