Splunk Search
Highlighted

Splunk rex help: regex for windows and unix path

New Member

Hi, I am a newbie to SPL. I am trying to write a regex that will extract the unix/windows path from the full_log field. I am having no luck with that. Can you please help? The following regex is for Windows. Thank you for your help.
HB

index="newindx" agent.name="*-svrname-*" "*checksum*" | rex field=full_log "^File\s+(?<checksum_changed>^\'[a-zA-Z]:\\[\\\S|*\S]?.*'$)\s+checksum\s+changed.+"

full_log: File '/apps/data/db.data' checksum changed.
full_log: File 'c:\windows\system32\xpsservices.dll' checksum changed.
0 Karma
Highlighted

Re: Splunk rex help: regex for windows and unix path

SplunkTrust
SplunkTrust

Try ... | rex field=full_log "File '(?<path>.*)[\\\/]\w+\.\w+'". If that doesn't work, you may need more escape characters so try ...| rex field=full_log "File '(?<path>.*)[\\\\\/]\w+\.\w+'".

---
If this reply helps you, an upvote would be appreciated.
0 Karma
Highlighted

Re: Splunk rex help: regex for windows and unix path

Path Finder

@hbustam8063

You can also use this.

...|rex " ( full_log: File\s\')(?<Path>(.*)+)[\/\\]\w+\.\w+'"

and to check your rex :- https://rubular.com/r/M2QDmpGvQr0Yts

Highlighted

Re: Splunk rex help: regex for windows and unix path

Contributor

Here is my attempt...

rex field=full_log "File\s\'(?<pathname>.+[\/\\])[^\\\/]+\'\schecksum\schanged\."

https://regex101.com/r/87ro6z/1

0 Karma
Highlighted

Re: Splunk rex help: regex for windows and unix path

Builder

Keep it simple!

rex field=full_log "^full_log:\sFile\s'(?<filename>[^']+)'\schecksum changed\."

Rather than trying to guess all legal characters, why not just tell rex "anything but a single quote" ?

This strategy will save you a lot of time, improve readability, and make your extractions much more durable.

See regex: https://regex101.com/r/iz1eYY/1

0 Karma
Highlighted

Re: Splunk rex help: regex for windows and unix path

Esteemed Legend

Like this:

... | rex field=full_log "'(?<NewFieldNameHere>[^']+)'"
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.