Splunk Search

HI Team , i want to extract 8.9 value from this string " service error rate 50x 8.976851851851853". can you please help

Hemant_h
Engager

" service error rate 50x 8.976851851851853"

field = " service error rate 50x 8.976851851851853"
need to extract 8.9 value from above string.

Labels (1)
0 Karma

bowesmana
SplunkTrust
SplunkTrust

Use the rex statement, for example this regex

| makeresults
| eval field = " service error rate 50x 8.976851851851853"
| rex field=field "service error rate\s+\w+\s+(?<value>\d+\.\d)"

 (this is an example you can run in a search window).

Change your regex statement to match what you expect in the data 

0 Karma
Get Updates on the Splunk Community!

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

 Prepare to elevate your security operations with the powerful upgrade to Splunk Enterprise Security 8.x! This ...

Get Early Access to AI Playbook Authoring: Apply for the Alpha Private Preview ...

Passionate about security automation? Apply now to our AI Playbook Authoring Alpha private preview ...

Reduce and Transform Your Firewall Data with Splunk Data Management

Managing high-volume firewall data has always been a challenge. Noisy events and verbose traffic logs often ...