Remove column using awk

farahjihan1993 · 03-02-2017, 01:55 AM

wanted to drop first 3 column;

This is my data;

DETAIL 02032017

Name Gender State School Class
A M Melaka SS D
B M Johor BB E
C F Pahang AA F
EOF 3
I want my data like this:

DETAIL 02032017
School Class
SS D
BB E
AA F
EOF 3

This is my current command that I get mycommandoutput:

awk -v date="$(date +"%d%m%Y")" -F\| 'NR==1 {h=$0; next}
{file="TEST_"$1"_"$2"_"date".csv";
print (a[file]++?"": "DETAIL"date"" ORS h ORS) $0 > file} END{for(file in a) print "EOF " a[file] > file}' testing.csv

Can anyone help me?

Thank you

I want to remove first three column

pan64 · 03-02-2017, 02:31 AM

please use [code]here comes your script[/code] to keep formatting of your original code.
how is this awk related to your goal? Do you want to modify testing.csv or the file created by this awk, or something else?
Is this your homework?

r3sistance · 03-02-2017, 06:01 AM

To me, it looks like what you infact want to do is just print the last two columns as opposed to removing the first three. Such as:

Code:

$ echo abc def ghi jkl | awk '{print $(NF-1) " " $NF }'
ghi jkl

Anyways, the easy way to do what you asked is just to set the fields to nothing

Code:

$ echo abc def ghi jkl | awk '{$1=$2=""; print $0}'
  ghi jkl