[SOLVED] Extract/Cut values from different columns in output?

kdar · 2012-11-14 02:24:34

I have following output when I run a command below:

$ likwid-powermeter sleep 5 | grep 'Joules\| s'
Runtime: 5.00299 s 
Energy consumed: 17.9783 Joules

I would like to extract only 5.00299 and 17.9783. How can I do this?

I tried to use awk and cut.. but I could not get it the way I wanted, I could only cut one column.. but those values are two different columns. 5.00299 is in 2nd column on first line and 17.9783 is in 3rd column in the 2nd line.

When I tried to pipe everything to cut I was getting following:

$ likwid-powermeter sleep 5 | grep 'Joules\| s' | cut -d' ' -f3                     
s                                                                                                                   
18.7806

What can I do?

Last edited by kdar (2012-11-14 06:34:14)

jasonwryan · 2012-11-14 02:57:08

awk 'NR==1{print $2} NR==2{print $3}'  < command

You could probably do without the grep as well; awk can handle that...

falconindy · 2012-11-14 03:15:44

awk '{ print $(NF -1) }'

jasonwryan · 2012-11-14 03:21:04

falconindy wrote:

awk '{ print $(NF -1) }'

Brutal.

kdar · 2012-11-14 03:42:27

wow.. thank all. I didn't know how to specify lines in awk.

How does NF -1 work?

falconindy · 2012-11-14 04:19:20

NF refers to the number of fields in the current line. $NF refers to the value of the last field. so... $(NF - 1) is the value of the next to last field.

Last edited by falconindy (2012-11-14 04:19:50)

ngoonee · 2012-11-14 05:39:54

Please mark [solved], as I'm pretty sure it is

Arch Linux

#1 2012-11-14 02:24:34

[SOLVED] Extract/Cut values from different columns in output?

#2 2012-11-14 02:57:08

Re: [SOLVED] Extract/Cut values from different columns in output?

#3 2012-11-14 03:15:44

Re: [SOLVED] Extract/Cut values from different columns in output?

#4 2012-11-14 03:21:04

Re: [SOLVED] Extract/Cut values from different columns in output?

#5 2012-11-14 03:42:27

Re: [SOLVED] Extract/Cut values from different columns in output?

#6 2012-11-14 04:19:20

Re: [SOLVED] Extract/Cut values from different columns in output?

#7 2012-11-14 05:39:54

Re: [SOLVED] Extract/Cut values from different columns in output?

Board footer