Splunk Search

rex capture groups - windows file name and path

brdr
Contributor

I'm attempting to capture 2 groups; a windows path and filename. I've successfully written the rex syntax and it works using strong textregex101.com*strong text* app.

| makeresults
| eval test="C:\WINDOWS\TEMP\ABCDE\HELP_WITHREX_64.EXE"
| rex field=test "(?<Path>^.+\\)(?<File>[^\\]+\.\w+$)"
| table Path File

However, when I use in Splunk I get an error "Regex: missing terminating ] for character class." Any idea why? thx.

Tags (1)
0 Karma
1 Solution

xpac
SplunkTrust
SplunkTrust

Yeah, the | rex command is a little tricky, as stuff has to be double-escaped. Try replacing \\ with \\\ - that should work.
Hint: This is usually not necessary in config files, but in searches, as those have to be escaped once for the SPL parser and once for the regex parser.

Hope that helps - if it does I'd be happy if you would upvote/accept this answer, so others could profit from it. 🙂

View solution in original post

xpac
SplunkTrust
SplunkTrust

Yeah, the | rex command is a little tricky, as stuff has to be double-escaped. Try replacing \\ with \\\ - that should work.
Hint: This is usually not necessary in config files, but in searches, as those have to be escaped once for the SPL parser and once for the regex parser.

Hope that helps - if it does I'd be happy if you would upvote/accept this answer, so others could profit from it. 🙂

brdr
Contributor

Ah, thanks xpac...

This is the change, and now works.

 rex field=test "(?<Path>^.+\\\)(?<File>[^\\\]+\.\w+$)"
0 Karma
Get Updates on the Splunk Community!

Index This | Forward, I’m heavy; backward, I’m not. What am I?

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

A Guide To Cloud Migration Success

As enterprises’ rapid expansion to the cloud continues, IT leaders are continuously looking for ways to focus ...

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...