Splunk Search

How do you make a regex that skips an optional word?

moorvogi
Path Finder

I'm fairly new to regex. In other languages, i just string split and hack it up as needed, but i'm trying to use regex w/ Splunk. I have 3 lines of text which I'll simplify for clarity.

timestamp and Stuff stringIWantOne and optionalWord stringIWantThree extra words
timestamp and Stuff stringIWantOne and stringIWantTwo extra words
timestamp and Stuff stringIWantOne and optionalWord stringIWantThree extra words

In this example, i want to grab the actual content of "stringIWantOne" and "stringIWantThree" as well as "stringIWantTwo".

stringIWantThree and Two are only ever 2 words.

the regex string i have right now is:

Interface\ (?Psrc_interface>.*), changed state to (?:administratively) (?P<port_status>\w+)

If i take out the (?:administratively) part, i almost get the desired results (up|down), but I also get "administratively". I want them to all be only "up | down" but I don't want to exclude the records that have the word administratively in it.

Tags (2)
0 Karma

aholzer
Motivator

This should do the trick:

Interface (?<src_interface>[^,]+), changed state to (administratively )?(?<port_status>\w+)

The '?' after the '(administratively )' capture group, basically tells the regex that the previous group/character is optional.

Used this as my sample data:

Interface 123, changed state to administratively up
Interface 234, changed state to administratively down
Interface 321, changed state to up
Interface 432, changed state to down

It catches all 4 distinct values of "src_interface" and "port_status".

I used regex101 to help double check the regex.

Hope this helps

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...