BASH or AWK: extract columns in multiple files and combine to a single file

cristalp · 03-15-2012, 10:57 AM

Dear all,

I have several files with multiple columns in each file. I want to extract the 2nd column from the first file and the 7th column from the second file and the 4th column from the third file and then put these 3 columns into a new file with format like below.

Code:

#This is to show the format of the new file with 3
#columns extracted from the 3 files
 
2nd           7th             4th
columns       columns         columns
of            of              of
the           the             the
first         second          third 
file          file            file

#END of the file

How could I do this in a simple way by bash script or awk?

Thanks for your help!

thinknix · 03-15-2012, 11:17 AM

Quote:

Originally Posted by cristalp

I have several files with multiple columns in each file. I want to extract the 2nd column from the first file and the 7th column from the second file and the 4th column from the third file and then put these 3 columns into a new file with format like below.

I've answered this one before, see here: http://www.linuxquestions.org/questi...script-739991/

Basically, it sounds like you want this, assuming the columns are comma-delimited:

Code:

paste -d, <(cut -d, -f2 file1.csv) <(cut -d, -f7 file2.csv) <(cut -d, -f4 file3.csv) > output.csv

grail · 03-15-2012, 11:55 AM

I would probably like to see what you have tried as this is not for your first attempt and have been assisted a number of times before.