Rta data needs regexp

ashokvpp · February 17, 2014, 4:26am

Hi

echo "rta=58.124001ms;100.000000;150.000000;0.000000"

I required 58.12 and 0.00 i,e from first and last.

I tried using : awk -F"rta=" '{print $2}' and last one awk -F";" '{print $4}' but unsuccessful.

Thanks

anbu23 · February 17, 2014, 4:32am

awk -F"[=;]" ' { print $2, $NF } '

ashokvpp · February 17, 2014, 4:36am

echo "rta=58.124001ms;100.000000;150.000000;0.000000 pl=0%;5;15;0" | awk -F"[=;]" ' { print $2, $NF } '
58.124001ms 0

I just required 58.12 and 0.00 - Could you please assist.

anbu23 · February 17, 2014, 4:48am

awk -F"[=;]" ' { printf("%.2f %.2f",$2, $NF) } '

24ajay · February 17, 2014, 4:54am

cat file1 | awk -F"[=;]" '{ print $2,$NF }' | cut -c 1-5," ",13-16

RudiC · February 17, 2014, 6:25pm

You didn't print that desired 0.000000 but the last single 0 that was not present in your post #1's sample.

rta=58.124001ms;100.000000;150.000000;0.000000 pl=0%;5;15;0"
                                      ^-desired           ^-printed

With this sample, even anbu23's formatted printout would not deliver the correct value. If the correct value is last in line, the proposals will work fine, if it's not, you need to supply more conditions how to identify it.