regex statement

JoshuaJohn — Fri, 26 Aug 2016 16:18:08 GMT

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

Re: regex statement

sundareshr — Fri, 26 Aug 2016 17:04:04 GMT

Try this regex

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

Re: regex statement

cdoebert — Fri, 26 Aug 2016 18:45:03 GMT

Use a positive lookbehind:

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

topic Re: regex statement in Splunk Search

regex statement

Re: regex statement

Re: regex statement