Splunk Search

How to separate results from extraction with multiple similar fields with regex?

SMM10
Explorer

I am looking through our current alerts and we have a few evaluations that occur like below.

Total_Trade: 129
Total_Value: 300
Total_Amount: 1000

I have a rex like below:

 

 

 

| rex max_match=0 Total_(?<Type>\w+):(?<amount>\w+)

 

 

 


Doing this though I get two fields with multiple events like below.

Type amount
Trade
Value
Amount
129
300
1000

 

What I wanted was each of these to be separate though/

Type amount

Trade

129
Value 300
Amount 1000
   
Labels (1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rex max_match=0 "Total_(?<Typeamount>\w+:\s*\w+)"
| mvexpand Typeamount
| rex field=Typeamount "(?<Type>\w+):\s*(?<amount>\w+)"
0 Karma
Get Updates on the Splunk Community!

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

&#x1f342; Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...

Transform your security operations with Splunk Enterprise Security

Hi Splunk Community, Splunk Platform has set a great foundation for your security operations. With the ...

Splunk Admins and App Developers | Earn a $35 gift card!

Splunk, in collaboration with ESG (Enterprise Strategy Group) by TechTarget, is excited to announce a ...