[SOLVED] awk command help

fredora · 11-25-2010, 01:48 PM

Hi All,

I have a file with 3 columns.

Billy 50 Comments are in the third column

I need to use 'awk' and create a program that outputs all comments. (The third field).
The problem with my current command is I can only print the first word of the 3rd column. Is there a way to print the full line, other than {print $3,$4,$5...}

This is what I have so far...

Code:

awk '/[A-Za-z.]/ {print $3}' data0

Thank you,

Mike

sycamorex · 11-25-2010, 02:04 PM

You can try:

Code:

awk '{ for(i=3; i<=NF; i++) {printf("%s ", $i)} print $NF }' file

rikijpn · 11-25-2010, 02:17 PM

This answer is uglier, but probably easier to understand if are not much experienced in programming/awk.

Code:

awk '{$1="";$2="";print substr($0,3)}'

This sets the first and second field to an empty string, and as the input field separators (spaces characters in this case) would remain, you'd have to print from the third character in the string (using substr).

A related page
.

fredora · 11-25-2010, 05:00 PM

Thank you, both answers work. Much appreciated!

grail · 11-25-2010, 05:23 PM

Just an alternative

Code:

awk '$2=$1="";sub(/^ */,"")' file