Splunk Search

Regular Expression to find the cases

akarivaratharaj
Communicator

I have to find a set of Exception names from my events. Below are the sample text and its corresponding Regular expression which I am trying

Sample Text:
1. Caused by: javax.transaction.TransactionRolledbackException:
2. Caused by: com.gtnexus.database.exception.NoEntryAffectedException:

Expression used:
rex field=_raw "Caused by: (?P^.(.+?)):"

Expect Result:
"TransactionRolledbackException"
"NoEntryAffectedException"

With my above regex I am getting "javax.transaction.TransactionRolledbackException" but I need only the exception name as "TransactionRolledbackException"

Could you please help me on this

0 Karma
1 Solution

andreacefali
Engager

Based on nittala answer:

rex field=_raw "Caused\sby\:\s.+\.(?<ExceptionName>[^:]+):"

This takes in consideration also an error that doesn't end with "Exception" word

View solution in original post

senthilgoa
Engager

(?[A-Z].*:)

(?
Assigned ==>
Starting Char ==> [A-Z]
Followed by any no char ==> .*
End with : ==> :
)

you get results like below

Match 1
Status= TransactionRolledbackException:
Match 2
Status= NoEntryAffectedException:

0 Karma

andreacefali
Engager

Based on nittala answer:

rex field=_raw "Caused\sby\:\s.+\.(?<ExceptionName>[^:]+):"

This takes in consideration also an error that doesn't end with "Exception" word

akarivaratharaj
Communicator

Wow! Thankyou!!

0 Karma

sudosplunk
Motivator

Hello, give this a try:

Note: I am assuming that exception name is always preceded by period .

rex field=_raw "Caused\sby\:\s.+\.(?<ExceptionName>\w+Exception):"

Tested here.

akarivaratharaj
Communicator

Thankyou for the response.

0 Karma

akarivaratharaj
Communicator

Both the answers by @nittala_surya and @andreacefali are useful. Thankyou for the quick help

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – November 2025

  Welcome to the inaugural edition of Data Management Digest! As your trusted partner in data innovation, the ...

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...