Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Match and print columns in second file
Top Forums Shell Programming and Scripting Match and print columns in second file Post 302627525 by birei on Friday 20th of April 2012 04:59:52 PM
Old 04-20-2012
Hi newpro,

One way:
Code:
$ cat file1
X1
X3
X4
$ cat file2
ID      X1      X2      X3      X4
A       1       6       2       1
B       2       7       3       3
C       3       8       4       1
D       4       9       1       1
$ cat script.awk 
BEGIN { 
        OFS = "\t" 
} 

FNR == NR { 
        f1[ $1 ] = 1
        next
} 

FNR < NR && FNR == 1 { 
        for ( i = 1; i <= NF; i++ ) { 
                if ( f1[ $i ] ) { 
                        header = header i 
                } 
        }
}

{ 
        for ( i = 1; i <= NF; i++ ) {
                if ( index( header, i ) > 0 ) {
                        printf $i OFS
                }
        }
        printf ORS
} 
$ awk -f script.awk file1 file2
X1      X3      X4
1       2       1
2       3       3
3       4       1
4       1       1

This User Gave Thanks to birei For This Post:
newpro
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get columns from another file for match in col 2 in 1st file

Hi, My first file has 592155 9 rs16916098 1 592156 19 rs7249604 1 592157 4 rs885156 1 592158 5 rs350067 12nd file has 9 rs16916098 0 113228129 2 4 19 rs7249604 0 58709070 4 2 2 rs17042833 0 113558750 4 2... (2 Replies)
Discussion started by: genehunter
2 Replies

2. Shell Programming and Scripting

Strings from one file which exactly match to the 1st column of other file and then print lines.

Hi, I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines). ################################# huge_file.txt a a ab b ################################## small_file.txt a 1.5 b 2.5 ab ... (4 Replies)
Discussion started by: AshwaniSharma09
4 Replies

3. Shell Programming and Scripting

print when column match with other file

Hello all, please help. There are two file like this: file1: 1197510.0 294777.7 9666973.0 21.6 1839.8 1197510.0 294777.7 9666973.0 413.2 2075.9 1197510.0 294777.7 9666973.0 689.3 2260.0 ... (1 Reply)
Discussion started by: attila
1 Replies

4. Shell Programming and Scripting

match two key columns in two files and print output (awk)

I have two files... file1 and file2. Where columns 1 and 2 of file1 match columns 1 and 2 of file2 I want to create a new file that is all file1 + columns 3 and 4 of file2 :b: Many thanks if you know how to do this.... :b: file1 31-101 106 0 92 31-101 106 29 ... (2 Replies)
Discussion started by: pelhabuan
2 Replies

5. Shell Programming and Scripting

Match two columns from two files and print output

Hello, I have two files which are of the following format File 1 which has two columns Protein_ID Substitution NP_997239 T53R NP_060668 V267M NP_058515 P856A NP_001206 T55M NP_006601 D371Y ... (2 Replies)
Discussion started by: nans
2 Replies

6. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies

7. UNIX for Advanced & Expert Users

Match and print based on columns

HI, I have 2 different questions in this thread. Consider 2 files as input (input file have different line count ) File 1 1 1 625 56 1 12 657 34 1 9 25 45 1 2 20 54 67 3 25 35 27 4 45 73 36 5 125 56 45 File2 1 1 878 76 1 9 83 67 2 20 73 78 4 47 22 17 3 25 67 99 (4 Replies)
Discussion started by: rossi
4 Replies

8. Shell Programming and Scripting

Match columns and print specific field

Hello, I have data in following format. ... (6 Replies)
Discussion started by: Pushpraj
6 Replies

9. Shell Programming and Scripting

Match Columns in one file and extract columns from another file

Kindly help merging information from two files with the following data structure. I want to match for the CHR-SNP in Foo and get the columns that match from CHROM-rsID Fields 1 & 2 of foo may have duplicates, however, a joint key of Fields $1$2$3$4 is unique. Also would be helpful to clean up... (4 Replies)
Discussion started by: genehunter
4 Replies

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies

LEARN ABOUT DEBIAN

cdk_position

cdk_position(3) 					     Library Functions Manual						   cdk_position(3)

NAME

       cdk_position - curses widget positioning key-bindings

SYNOPSIS

       Position methods for the Cdk widgets allow the user to move the widget around the screen via the cursor/keypad keys.

DESCRIPTION

       The following key bindings can be used to move the widget around the screen.

					    +---------------------------------------------------------------+
					    |Key	       Action					    |
					    +---------------------------------------------------------------+
					    |Up Arrow	       Moves the widget up one row.		    |
					    |Down Arrow        Moves the widget down one row.		    |
					    |Left Arrow        Moves the widget left one column 	    |
					    |Right Arrow       Moves the widget right one column	    |
					    |1		       Moves  the  widget down one row and left one |
					    |		       column.					    |
					    |2		       Moves the widget down one row.		    |
					    |3		       Moves the widget down one row and right	one |
					    |		       column.					    |
					    |4		       Moves the widget left one column 	    |
					    |5		       Centers the widget both vertically and hori- |
					    |		       zontally.				    |
					    |6		       Moves the widget right one column	    |
					    |7		       Moves the widget up one	row  and  left	one |
					    |		       column.					    |
					    |8		       Moves the widget up one row.		    |
					    |9		       Moves  the  widget  up one row and right one |
					    |		       column.					    |
					    |t		       Moves the widget to the top of the screen.   |
					    |b		       Moves  the  widget  to  the  bottom  of	the |
					    |		       screen.					    |
					    |l		       Moves the widget to the left of the screen.  |
					    |r		       Moves the widget to the right of the screen. |
					    |c		       Centers	the  widget  between  the  left and |
					    |		       right of the window.			    |
					    |C		       Centers the widget between the top and  bot- |
					    |		       tom of the window.			    |
					    |Escape	       Returns the widget to its original position. |
					    |Return	       Exits  the  function  and  leaves  the  wid- |
					    |		       getwhere it was. 			    |
					    +---------------------------------------------------------------+
					    +---------------------------------------------------------------+
       The numbers 0-9 are chosen to correspond to the numeric keypad on your terminal.  Cdk does not handle the application mode  keypad  control
       sequences, since those are not defined via terminfo.  To use the numeric keypad you should ensure that it is in normal (or NumLock) mode.

SEE ALSO

       cdk(3), cdk_binding(3), cdk_display(3), cdk_screen(3)

																   cdk_position(3)
All times are GMT -4. The time now is 01:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy