Splunk Search

regex statement

JoshuaJohn
Contributor

I am trying to extract the response time from this statement (Just the number, not the words response time or the ms behind it)
Here is a regex statement I wrote ((response time: )(\w+)) this is splitting the number into the 3rd group but I am unsure as to how to remove the other two groups from the results as I need them to help with the matching aspect

Here is the statement I am trying to extract from:
<117>Aug 26 15:22:16 777-120 SLAVE[p-core_987734]: 2016-08-26 15:22:16,7t2 INFO [q44760481-48788] 6699-4871-a646-1b15556d queriesAndResponseTimeLogger - Client request: /search?keyword=tools+accessories&sendRefinements=false&count=3, response time: 70 ms, stage1Count=0, stage2Count=13, effectiveStage=STAGE2

The bolded number is the one I want

0 Karma
1 Solution

sundareshr
Legend

Try this regex

"response\stime\:\s+(?<response_time>\d+)\s"

View solution in original post

cdoebert
Path Finder

Use a positive lookbehind:

(?<=response time: )(\w+)
0 Karma

sundareshr
Legend

Try this regex

"response\stime\:\s+(?<response_time>\d+)\s"
Get Updates on the Splunk Community!

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

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...