topic Re: How do I modify my rex command to remove directory location from path? in Getting Data In

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

jeradb — Tue, 05 Mar 2024 20:14:02 GMT

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\

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

yuanliu — Wed, 06 Mar 2024 02:01:13 GMT

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.