AWK – Print All Columns from nth to Last

awkcygwinlinuxshell

This line worked until I had whitespace in the second field:

svn status | grep '\!' | gawk '{print $2;}' > removedProjs

Is there a way to have awk print everything in $2 or greater? ($3, $4.. until we don't have any more columns?)

I'm doing this in a Windows environment with Cygwin.

Best Answer

Print all columns:

awk '{print $0}' somefile

Print all but the first column:

awk '{$1=""; print $0}' somefile

Print all but the first two columns:

awk '{$1=$2=""; print $0}' somefile

Related Solutions

AWK – How to Print Second-to-Last Column/Field

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

Should work

AWK – Print All Columns from Nth to Last with Spaces

Since you want to preserve spaces, let's just use cut:

$ cut -d' ' -f2- file
1 o p
2 o p p
3 o p p  p

Or for example to start by column 4:

$ cut -d' ' -f4- file
p
p p
p p  p

This will work as long as the columns you are removing are one-space separated.

If the columns you are removing also contain different amount of spaces, you can use the beautiful solution by Ed Morton in Print all but the first three columns:

awk '{sub(/[[:space:]]*([^[:space:]]+[[:space:]]+){1}/,"")}1'
                                                   ^
                                        number of cols to remove

Test

$ cat a
a 1 o p
b    2 o p p
c  3 o p p  p
$ awk '{sub(/[[:space:]]*([^[:space:]]+[[:space:]]+){2}/,"")}1' a
o p
o p p
o p p  p

Best Answer

Related Solutions

AWK – How to Print Second-to-Last Column/Field

AWK – Print All Columns from Nth to Last with Spaces

Test

Related Question