Splunk Search

Regex generation

Deepz2612
Explorer

I have the below set of events where I wanted to write regex to capture only the last word

Kindly help

Tags (1)
0 Karma

woodcock
Esteemed Legend

Like this:

... | rex "(?<LastWord>\w+)$"
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi Deepz2612,
I don't see the set of events.
Anyway, to extract the last word od an event and put it in a field, you could use a regex like this:

| rex "\s+(?<my_field>\w+)$"

that you can test at https://regex101.com/r/hofrdl/1 .

Ciao.
Giuseppe

rmmiller
Contributor

Assuming you just want the last word in each event, this should work fine:

.+\b(\w+)$

If you want a more restrictive match, looking for only "begin" or "end", then this should work:

.+\b(begin|end)$

Hope that helps!
rmmiller

Edit: Used https://regexr.com/ to test/generate regex.

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...