Solved: Extract fields using regex

siddharthmis · ‎09-09-2016

I have the data like:

2016-09-09 06:21:31,858 ... blah ... blah...
... ORA-00001: unique constraint (AN_FIELD.CODE) violated...
... ORA-06512: at "AN_FIELD.DATA_TRANSFER", line 5523...

I would like to extract "ORA-00001: unique constraint (AN_FIELD.CODE) violated" and "FIELD" separately.

How can I do this?

sundareshr · ‎09-09-2016

See if this works

... | rex "(?<msg>ORA.*\(AN\_(?<field>\w+).*)" | table msg field

View solution in original post

siddharthmis · ‎09-09-2016

Both seems to work, Thanks for the super fast response.

richgalloway · ‎09-09-2016

Try this

(?<msg>ORA-00001:.*?_(?<field>[^\.]+)\..*violated)

---
If this reply helps you, Karma would be appreciated.

sundareshr · ‎09-09-2016

See if this works

... | rex "(?<msg>ORA.*\(AN\_(?<field>\w+).*)" | table msg field

Extract fields using regex

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Automating Threat Operations and Threat Hunting with Recorded Future

Join the Conversation