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!

Demo Day: Strengthen Your SOC with Splunk Enterprise Security 8.1

Today’s threat landscape is more complex than ever. Security operation centers (SOCs) are overwhelmed with ...

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...