Splunk Search

Extract substring with mutiple [ in a string

rreddy
Observer

I have a String is in the pattern:

[substring1][substring2][substring3] Spark App State changed to FAILED. Total time taken is 10 minutes

I want to extract it into 4 fileds:

Field1 = substring1

Field2 = substring2

Field3 = substring3

Field4 = 10 

Please help.

Labels (3)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rex "\[(?<field1>[^\[]+)\]\[(?<field2>[^\[]+)\]\[(?<field3>[^\[]+)\].*Total time taken is (?<field4>\d+)"
0 Karma
Got questions? Get answers!

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

Meet up IRL or virtually!

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

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Casting Call: Compete in Cyber Games

Lights, Camera, SecOps: Apply to Compete in Cyber Games     Think you have what it takes to beat the clock? ...

How Edge Processor's Durable Queue Works

Edge Processor sits in one of the most consequential places in any Splunk pipeline: between your data sources ...