awk - Matching columns between 2 files and reordering results Post: 302464636

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

matching columns from two files

Hey, I have two files that have exactly the same format. They are both tab-delimited and contain 12 columns. However the # of rows vary. What I want to do is match columns # 5,6 and 7 between the two files. If they do match exactly (based on numbers) then I want the whole row from file 2 to...

2. UNIX for Dummies Questions & Answers

Matching corresponding columns in two different files

Hi to all, I have two separated files: FILE1 "V1" "V2" "V3" Mary James Nicole Robert Francisco Sophie Nancy Antony Matt Josephine Louise Rose Mark Simon Charles FILE2 "V1" "V2" "V3"...

3. Shell Programming and Scripting

Help with awk Matching columns from two files

Hello, I have two files as following: #bin chrom chromStart chromEnd name score strand observed 585 chr2 29442 29443 rs4637157 0 + C/T 585 chr2 33011 33012 rs13423995 0 + A/G 585 chr2 34502 34503 rs13386087 0 + ...

4. Shell Programming and Scripting

Merge two files matching columns

Hi! I need to merge two files when col1 (x:x:x) matching and adds second column from file1.txt. # cat 1.txt aaa;a12 bbb;b13 ccc;c33 ddd;d55 eee;e11 # cat 2.txt bbb;b55;34444;d55 aaa;a15;35666;a44 I try with this awk and I get succesfully first column from 1.txt: # awk -F";"...

5. Shell Programming and Scripting

Join two files with matching columns

Hi, I need to join two files together with one common value in a column. I think I can use awk or join or a combination but I can't quite get it. Basically my data looks like this, with the TICKER columns matching up in each file File1 TICKER,column 1, column, 2, column, 3, column 4 ...

6. Shell Programming and Scripting

awk to copy previous line matching a particular columns

Hello Help, 2356798 7689867 999 000 123678 20385907 9797 666 17978975 87468976 968978 98798 I am trying to have out put which actually look for the third column value of 9797 and then it insert line there after with first, second column value exactly as the previous line and replace the third...

7. Shell Programming and Scripting

awk - matching on 2 columns for differents lines

Given this file (I separated them in block to make my explanation clearer): 92157768877;Sof_deme_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0 92157768877;Sof_trav_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0 91231838895;Sof_deme_faible_Email_am;EMAIL;26/01/2015;1 0;0...

8. Shell Programming and Scripting

awk merge matching columns

I know I'm not the first one asking this but my code still does not work: File 1: gi|1283| tRNAscan exon 87020 88058 . - . transcript_id "Parent=tRNA-Tyr5.r01"; gi|3283| tRNAscan exon 97020 97058 . + . transcript_id "Parent=tRNA-Tyr6.r01"; gi|4283| rRNAscan exon 197020 197058 . - . transcript_id...

9. Shell Programming and Scripting

Joining Two Files Matching Two Columns

Hi All, I am looking to join two files where column 1 of file A matches with column 1 of file B and column 5 of files A matches with column 2 of file B. After joining the files based on above condition, out should contain entire line of file A and column 3, 4 and 5 of file B. Here is sample...

10. Shell Programming and Scripting

awk Matching Columns - Am I missing something?

I am using awk to match columns and output based on those matches. For some reason it is not printing matching columns, am I missing something? Operating system - windows with cygwin. Command that I am using: sed 's/]*,]*/,/g' $tempdir/file1 > $tempdir/file1.$$ && awk -F, 'FNR==NR{f2=$2...

LEARN ABOUT SUNOS

x_buttontest

x_buttontest(6) 						  Games and Demos						   x_buttontest(6)

NAME

       x_buttontest - Xview demonstration and test program for SunButtons

SYNOPSIS

       /usr/demo/BUTTONBOX/x_buttontest

DESCRIPTION

       x_buttontest  is an Xview application that displays a window  with thirty two buttons, corresponding to those on the  SunButtons buttonbox.
       To determine if the buttonbox has been set up correctly, select the Diagnostic button on the panel. If the buttonbox is functional and cor-
       rectly  interfaced,  each of the buttons will light in  sequence for about 1 second. Then "OK." is sent to the  standard output of the demo
       program. x_buttontest is now in its (default) interactive mode. Pressing a button on the buttonbox highlights the corresponding	button	on
       the  screen.  Additionally, x_buttontest sends a BDIOBUTLITE ioctl to the buttonbox in response to each key press and key  release, so that
       the button light is illuminated while the  button is held down.

       If the serial communications become confused, as can happen when both the buttonbox and the dialbox are operated at the same time,  one	or
       more button lights may remain on after the button is released.  Clicking on the Reset button on the panel will unconditionally turn all the
       button lights off.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Architecture		     |SPARC			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       bdconfig(1M), attributes(5), x_dialtest(6), bd(7M), streamio(7I)

SunOS 5.10							    1 Jan 1997							   x_buttontest(6)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

matching columns from two files

Discussion started by: phil_heath

2. UNIX for Dummies Questions & Answers

Matching corresponding columns in two different files

Discussion started by: eleonoral

3. Shell Programming and Scripting

Help with awk Matching columns from two files

Discussion started by: Homa

4. Shell Programming and Scripting

Merge two files matching columns

Discussion started by: fhluque