Sponsored Content
Top Forums Shell Programming and Scripting Match files based on either of the two columns awk Post 302827263 by smitra on Friday 28th of June 2013 10:50:52 AM
Old 06-28-2013
Dear zaxxon,
Thank you very much. But it still producec the similar output which I already got.
But I have the file bit more complicated. I am editing your example. Thanks for creating the example.
Code:
$ cat file1
1000094 2
10039307 1
10039641 1
10954458 11
10047359 1
10954459 2
10120302 1
10954460 13
10121776 1
10121865 32
$ cat file2
protein_gi GeneID Symbol
10954455 1246500 repA1
10954457 1246501 repA2
10954458 1246502 leuA
10954459 1246503 leuB
10954460 1246504 leuC
10954461 1246505 leuD
31982990 10121776 ibp
31982991 1246510 repA1
10954456 1000094 pLeuDn_02

Now I want this output
Code:
10954458 1246502 leuA 11
10954459 1246503 leuB 2
10954460 1246504 leuC 13
31982990 10121776 ibp 1
10954456 1000094 pLeuDn_02 2


Your advice will be really helpful..
Thanks in advance,
Best wishes,
Mitra

Last edited by smitra; 06-28-2013 at 11:56 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk 3 files to one based on multiple columns

Hi all, I have three files, one is a navigation file, one is a depth file and one is a file containing the measured field of gravity. The formats of the files are; navigation file: 2006 320 17 39 0 0 *nav 21.31542 -157.887 2006 320 17 39 10 0 *nav 21.31542 -157.887 2006 320 17 39 20 0... (2 Replies)
Discussion started by: andrealphus
2 Replies

2. Shell Programming and Scripting

match columns using awk

Hi All, I need some help in writing a small script using Awk. My input file has following deatils A,B,C,D 8239359,8239359,8388125,8388125 8239359,8239359,8388125,8388125 7165981,7165981,8363138,8363138 8283830,8283830,8382987,8382987 8209964,8209964,8367098,8367098 ... (8 Replies)
Discussion started by: pistachio
8 Replies

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 ... (2 Replies)
Discussion started by: pelhabuan
2 Replies

4. Shell Programming and Scripting

awk script to split file into multiple files based on many columns

So I have a space delimited file that I'd like to split into multiple files based on multiple column values. This is what my data looks like 1bc9A02 1 10 1000 FTDLNLVQALRQFLWSFRLPGEAQKIDRMMEAFAQRYCQCNNGVFQSTDTCYVLSFAIIMLNTSLHNPNVKDKPTVERFIAMNRGINDGGDLPEELLRNLYESIKNEPFKIPELEHHHHHH 1ku1A02 1 10... (9 Replies)
Discussion started by: viored
9 Replies

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

6. Shell Programming and Scripting

New files based off match or no match

Trying to match $2 in original_targets with $2 of new_targets . If the two numbers match exactly then a match.txt file is outputted using the information in the new_targets in the beginning 4 fields $1, $2, $3, $4 and value of $4 in the original_targets . If there is "No Match" then a no... (2 Replies)
Discussion started by: cmccabe
2 Replies

7. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies

8. Shell Programming and Scripting

Comparing two columns in two files and printing a third based on a match

Hello all, First post here. I did not notice a previous post to help me down the right path. I am looking to compare a column in a CSV file against another file (which is not a column match one for one) but more or less when a match is made, I would like to append a third column that contains a... (17 Replies)
Discussion started by: dis0wned
17 Replies

9. Shell Programming and Scripting

awk to create subdirectory based on match between two files

In the below awk I am trying to mkdir based of an exact match between file2 line starting with R_2019.... and file1 line starting with R_2019. When a match is found there is a folder located at /home/cmccabe/run with the same name as the match where each $2 in file1 is a new subdirectory in that... (2 Replies)
Discussion started by: cmccabe
2 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
TAGGREPPER(1)							   User Commands						     TAGGREPPER(1)

NAME
taggrepper - search and match tags of media file for regular expressions SYNOPSIS
taggrepper [--tag-label regexp]... [--display-taglabel]... [FILE/DIRECTORY]... DESCRIPTION
Perform a regular expression search on the tags of specified media files. Mandatory arguments to long options are mandatory for short options too. All regular expressions are Perl Compatible Regular expressions supported by the PCRE libraries. Note that all matches are ANDed, meaning that for a successful match, matches against all tags must occur. Support exists for MP3 files, and, if compiled in, for Ogg Vorbis and FLAC files as well. -t, --title=REGEXP Match the title tag against REGEXP -a, --artist=REGEXP Match the artist tag against REGEXP -l, --album=REGEXP Match the album, tag against REGEXP -y, --year=REGEXP Match the year tag against REGEXP -g, --genre=REGEXP Match the genre tag against REGEXP -c, --comment=REGEXP Match the comment tag against REGEXP --track=REGEXP Match the track tag against REGEXP -c, --composer=REGEXP Match the composer tag against REGEXP -o, --orig-artist=REGEXP Match the original artist tag against REGEXP -c, --copyright=REGEXP Match the copyright tag against REGEXP -u, --url=REGEXP Match the URL tag against REGEXP -e, --encoded-by=REGEXP Match the encoded-by tag against REGEXP --any-tag=REGEXP Match the encoded-by tag against REGEXP. Using this option makes every one of the above options to be ignored --display-title display title tag of matching files --display-artist display artist tag of matching files --display-album display album tag of matching files --display-year display year tag of matching files --display-genre display genre tag of matching files --display-comment display comment tag of matching files --display-track display track tag of matching files --display-composer display composer tag of matching files --display-orig-artist display orig-artist tag of matching files --display-copyright display copyright tag of matching files --display-url display url tag of matching files --display-encoded-by display encoded-by tag of matching files -0, --print0, Use null character as delimiter. This option can be used with -0 option of xargs. -r, --recursive Search directories recursively -v, --version Display version and exit -h, --help Display this help message All regular expressions are PCRE regular expressions. Refer to the PCRE documentation for details. Report comments and bugs to a.kumar@alumni.iitm.ac.in COPYING
Copyright (C) Kumar Appaiah License: BSD License (see COPYING file in the distribution tarball for details) This program is free software; you can distribute it under the terms of the BSD License. See the file COPYING in the tarball, or /usr/share/common-licenses/BSD on Debian-based systems. SEE ALSO
pcre(3) taggrepper 0.01 July 2009 TAGGREPPER(1)
All times are GMT -4. The time now is 08:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy