Match the columns between two files and output Post: 302963384

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match strings in two files and compare columns of both

Good Morning, I was wondering if anybody could tell me how to achieve the following, preferably with a little commenting for understanding. I have 2 files, each with multiple rows with multiple columns. I need to find each row where the value in column 1 of file 1 matches column 1...

2. UNIX for Dummies Questions & Answers

Two files; if cells match then copy over other columns

My current issue is dealing with two space delimited files. The first file has column 1 as the sample ID's, then columns 2 - n as the observations. The second file has column 1 as the sample ID's, column 2 as the mother ID's, column 3 as the father ID's, column 4 as the gender, and column 5...

3. 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 ...

4. Shell Programming and Scripting

Match columns several files

Hey fellas! Here come my problem. I appreciate if you have a look at it. I have several files with following structure: file_1:1 21 4 45 file_2:2 31 4 153 6 341 and so on... and I have a 'reference' file look like this: File_ref:A 1 B 2 C 3

5. Shell Programming and Scripting

Match files based on either of the two columns awk

Dear Shell experts, I have 2 files with structure: File 1: ID and count head test_GI_count1.txt 1000094 2 10039307 1 10039641 1 10047177 11 10047359 1 1008555 2 10120302 1 10120672 13 10121776 1 10121865 32 And 2nd file: head Protein_gi_GeneID_symbol.txt protein_gi GeneID...

6. 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 ...

7. Shell Programming and Scripting

Match the columns between 2 files

I have two files I want to match ids in the 5th column of the file 1 with the first column of the file 2 and get the description for the matched ids as shown in the output sno nm no nm2 ID 1 cc 574372 yyyi |6810|51234| 2 bb 119721 nmjk |6810|51234|51179| ...

8. Shell Programming and Scripting

Join two files combining multiple columns and produce mix and match output

I would like to join two files when two columns in each file matches with each other and then produce an output when taking multiple columns. Like I have file A 1234,ABCD,23,JOHN,NJ,USA 2345,ABCD,24,SAM,NY,USA 5678,GHIJ,24,TOM,NY,USA 5678,WXYZ,27,MAT,NJ,USA and file B ...

9. Shell Programming and Scripting

Match first two columns and average third from multiple files

I have the following format of input from multiple files File 1 24.01 -81.01 1.0 24.02 -81.02 5.0 24.03 -81.03 0.0 File 2 24.01 -81.01 2.0 24.02 -81.02 -5.0 24.03 -81.03 10.0 I need to scan through the files and when the first 2 columns match I...

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...

LEARN ABOUT SUSE

atr_analysis

ATR_ANALYSIS(1p)						   User Commands						  ATR_ANALYSIS(1p)

NAME

       ATR_analysis - analyse a smart card ATR

SYNOPSIS

       ATR_analysis [ATRstring]

DESCRIPTION

       ATR_analysis is used to parse the ATR (Answer To Reset) sent by a smart card.

       The command also tries to find the card model using an ATR database stored in a text file smartcard_list.txt.

       The smartcard_list.txt file is searched in ./, /usr/local/pcsc/ and /usr/share/pcsc/ directories.

       Exemple:
	$ ATR_analysis '3B A7 00 40 18 80 65 A2 08 01 01 52'
	ATR: 3B A7 00 40 18 80 65 A2 08 01 01 52
	+ TS = 3B --> Direct Convention
	+ T0 = A7, Y(1): 1010, K: 7 (historical bytes)
	  TB(1) = 00 --> Programming Param P: 0, I: 0
	  TD(1) = 40 --> Y(i+1) = 0100, Protocol T = 0
	-----
	  TC(2) = 18 --> Work waiting time: 960 x 24 x (Fi/F)
	+ Historical bytes: 80 65 A2 08 01 01 52

	Possibly identified card:
	3B A7 00 40 18 80 65 A2 08 01 01 52
	       Gemplus GPK8000

BUGS

       Maybe many bugs since I am not a ISO 7816 expert.

FILES

       smartcard_list.txt

SEE ALSO

       pcscd(8), pcsc_scan(1)

AUTHOR

       Ludovic Rousseau <ludovic.rousseau@free.fr>

Version: 1.3							   October 2005 						  ATR_ANALYSIS(1p)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match strings in two files and compare columns of both

Discussion started by: GarciasMuffin

2. UNIX for Dummies Questions & Answers

Two files; if cells match then copy over other columns

Discussion started by: Renyulb28

3. Shell Programming and Scripting

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

Discussion started by: pelhabuan

4. Shell Programming and Scripting

Match columns several files

Discussion started by: @man