Shell Programming and Scripting

Someone help please. I tried to do it with findstr but I couldn't, so now I'm trying to output the following numbers from this text file with gawk (what I need is in bold down below):


Analyzing pool.ntp.org (1 of 1)...
delayoffset from local clock
Stratum: 2

Warning:
Reverse name resolution is best effort. It may not be
correct since RefID field in time packets differs across
NTP implementations and may not be using IP addresses.



pool.ntp.org[155.101.3.115:123]:
ICMP: 73ms
NTP: +0.0162516s RefID: 127-67-113-92.pool.ukrtel.net [92.113.67.127]


What I want to output is in bold. How can I do this with Gawk? With my noob knowledge I can only output:

Code:

+0.0162516s       RefID

But I would like to just have

Code:

0.0162516

Is this possible?

I'm guessing that you're using something like...

Code:

$ awk -F: '$1=="NTP"{print $2}' file1
 +0.0162516s RefID

If so, then just add gsub...

Code:

$ awk -F: '$1=="NTP"{gsub(/[^0-9\.]*/,"",$2);print $2}' file1
0.0162516

I appreciate the response.

The command I used was:

Code:

 gawk -F":" "/NTP/{print $2}" time.txt

I can't get your code to work, it is probably because I'm using "gawk for windows".. http://gnuwin32.sourceforge.net/packages/gawk.htm

When I use your code I get this response:

Escape the quotes like:

Code:

awk -F":" "$1==\"NTP\"{gsub(/[^0-9\.]*/,\"\",$2);print $2}" file

Code:

echo "pool.ntp.org[155.101.3.115:123]:
ICMP: 73ms
NTP: +0.0162516s RefID: 127-67-113-92.pool.ukrtel.net [92.113.67.127]" |awk '/NTP/{print gensub(/(.*NTP: \+)(.*[0-9]s)
(Ref.*)/,"\\2",1,$0)}'
0.0162516s

Thanks Franklin52 , but I just get a blank output.

---------- Post updated at 02:48 AM ---------- Previous update was at 02:46 AM ----------

I have no idea how to use your code yinyuemi lol.

Code:

awk '/NTP/{print gensub(/(.*NTP: \+)(.*[0-9]s)(Ref.*)/,"\\2",1,$0)}' yourfile