Splunk Search

How to write regex for rex command to extract value after a colon?

valameti
Explorer

Hi,
Can any one help me how to display the below value which is in double quotation using rex command
API : IO ET :"2465ms"

0 Karma
1 Solution

pradeepkumarg
Influencer
....| rex "(?i)\s\:\"(?P.*?\d+ms)\W" | table DURATION

View solution in original post

esix_splunk
Splunk Employee
Splunk Employee
... | rex "API\s\:\sIO\sET\s\:\"(?<myvalue>\d+)ms\"" | table myvalue

That will also capture based on the text match before, leading up to the quotes, capture in the quotes up to the ms label.

0 Karma

pradeepkumarg
Influencer
....| rex "(?i)\s\:\"(?P.*?\d+ms)\W" | table DURATION
Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...