Splunk Search

Regex to extract a word after word and comma

dtccsundar
Path Finder

i have 2 requirements 

1) From different events in need to extract the word after Interface  and Comma. After Interface there will be a space .Field name can be Interface

2) Need to extract a new field with name Activity with values either Up or Down .I have marked in bold in the events .

Ex- 

1) Mar 5 05:45:43 ie-dub-corp-sw1 Eastern: %LINEPROTO-5-UPDOWN: Line protocol on Interface GigabitEthernet2/0/19, changed state to down

2) Mar 5 05:46:50 omenmnlswfl02 EST: %LINEPROTO-5-UPDOWN: Line protocol on Interface GigabitEthernet2/3, changed state to up

Please help me with 2 regex .

 

 

Labels (3)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @dtccsundar,

if you want only one regex, you can use

| rex "Interface\s+(?<interface>[^,]+), changed state to (?<state>\w+)"

if you prefer two regexes, you can use:

| rex "Interface\s+(?<interface>[^,]+)"
| rex ""changed state to (?<state>\w+)"

you can test the regx at https://regex101.com/r/WpmBG3/1

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

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

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...