Splunk Search

How to remove Windows subfolders from search results by using regular expression?

erictodor
New Member

I have a search which produces c:\folder\folder\folder\folder\file.exe as results. I want to remove all of the c:\folders so I'm only left with file.exe. Its unknown how many subfolders may exist in my search. I'm still new to regex searching so I managed to get the query I want in a simulator but I can't get splunk to produce the results.

Expression [^\\\]*$

| rex field=Filepath "(?<'Path'>[^\\\]*$)" 

Any help would be appreciated

0 Karma
1 Solution

somesoni2
Revered Legend

Give this a try (run anywhere sample, replace line 1 with your search)

| gentimes start=-1 | eval FilePath="c:\folder\folder\folder\folder\file.exe" | table FilePath 
| rex field=FilePath "\\\(?<path>\w+\.\w+)$"

View solution in original post

0 Karma

somesoni2
Revered Legend

Give this a try (run anywhere sample, replace line 1 with your search)

| gentimes start=-1 | eval FilePath="c:\folder\folder\folder\folder\file.exe" | table FilePath 
| rex field=FilePath "\\\(?<path>\w+\.\w+)$"
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...