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
SplunkTrust
SplunkTrust

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
SplunkTrust
SplunkTrust

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!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...