Sponsored Content
Top Forums Shell Programming and Scripting Matching 2 files based on one column Post 302470989 by swvanderlaan on Thursday 11th of November 2010 04:04:28 PM
Old 11-11-2010
Matching 2 files based on one column

Hi,

On a similar subject, the following. I have two files:

file1.txt
Code:
dbSNP_rsID,Chromosome,Position,Gene
rs10399749,chr. 01,45162,?
rs4030303,chr. 01,72434,?
rs4030300,chr. 01,72515,?
rs940550,chr. 01,78032,?
rs13328714,chr. 01,81468,?
rs11490937,chr. 01,222077,?
rs6683466,chr. 01,524446,"OR4F29, OR4F16, OR4F3"
rs12025928,chr. 01,536560,"OR4F29, OR4F16, OR4F3"

file2.txt
Code:
dbSNP_rsID	R_square
rs6650104	0.000
rs9629043	0.000
rs11497407	0.000
rs12565286	0.332
rs11804171	0.338
rs2977670	0.352
rs2977656	0.000

And now I would like to match the files (file1 to file2) on dbSNP_rsID so that I get a new file:

file_new.txt
dbSNP_rsID,R_square,Chromosome,Position,Gene
rs12565286,0.332,chr. 01,711153,"OR4F29, OR4F16, OR4F3"


I've really tried to understand the code you guys have supplied, but I really don't understand. SmilieCould you please help me with a code? Smilie

Thanks!

Sander

Last edited by Franklin52; 11-12-2010 at 05:44 AM.. Reason: Please use code tags!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare files column to column based on keys

Here is my situation. I need to compare two tab separated files (diff is not useful since there could be known difference between files). I have found similar posts , but not fully matching.I was thinking of writing a shell script using cut and grep and while loop but after going thru posts it... (2 Replies)
Discussion started by: blackjack101
2 Replies

2. Shell Programming and Scripting

Matching words based on column headers

Hi , Pls help on this. Input file: NAME1 BSC1 TEXT ID 1 MAINSFAIL TEXT ID 2 DGON TEXT ID 3 lOADONDG NAME2 BSC2 TEXT ID 1 DGON TEXT ID 3 lOADONG (1 Reply)
Discussion started by: bha148
1 Replies

3. UNIX for Dummies Questions & Answers

Removing Lines based on matching first column

I have a file1 that looks like this: File 1 a b b c c e d e and a file 2 that looks like this: File 2 b c e e Note that file 2 is the right hand column from file1. I want to remove any lines from file1 that begin with the column in file2. In this case the desired output... (6 Replies)
Discussion started by: kschiltz55
6 Replies

4. Shell Programming and Scripting

awk print non matching lines based on column

My item was not answered on previous thread as code given did not work I wanted to print records from file2 where comparing column 1 and 16 for both files find rows where column 16 in file 1 does not match column 16 in file 2 Here was CODE give to issue ~/unix.com$ cat f1... (0 Replies)
Discussion started by: sigh2010
0 Replies

5. UNIX for Dummies Questions & Answers

How to fetch files right below based on some matching criteria?

I have a requirement where in i need to select records right below the search criteria qwertykeyboard white 10 20 30 30 40 50 60 70 80 qwertykeyboard black 40 50 60 70 90 100 qwertykeyboard and white are headers separated by a tab. when i execute my script..i would be searching... (4 Replies)
Discussion started by: vinnu10
4 Replies

6. Shell Programming and Scripting

Based on column in file1, find match in file2 and print matching lines

file1: file2: I need to find matches for any lines in file1 that appear in file2. Desired output is '>' plus the file1 term, followed by the line after the match in file2 (so the title is a little misleading): This is honestly beyond what I can do without spending the whole night on it, so I'm... (2 Replies)
Discussion started by: pathunkathunk
2 Replies

7. Shell Programming and Scripting

Matching two files per column

Hi, I hope somebody can help me with this problem, since I would like to solve this problem using awk, but im not experienced enough with this. I have two files which i want to match, and output the matching column name and row number. One file contains 4 columns like this: FILE1: a ... (6 Replies)
Discussion started by: Jenna.bos
6 Replies

8. Shell Programming and Scripting

Insert value of column based on file name matching

At the top of the XYZ file, I need to insert the ABC data value of column 2 only when ABC column 1 matches the prefix XYZ file name (not the ".txt"). Is there an awk solution for this? ABC Data 0101 0.54 0102 0.48 0103 1.63 XYZ File Name 0101.txt 0102.txt 0103.txt ... (7 Replies)
Discussion started by: ncwxpanther
7 Replies

9. Linux

Merge two files based on matching criteria

Hi, I am trying to merge two csv files based on matching criteria: File description is as below : Key_File : 000|ÇÞ|Key_HF|ÇÞ|Key_FName 001|ÇÞ|Key_11|ÇÞ|Sort_Key22|ÇÞ|Key_31 002|ÇÞ|Key_12|ÇÞ|Sort_Key23|ÇÞ|Key_32 003|ÇÞ|Key_13|ÇÞ|Sort_Key24|ÇÞ|Key_33 050|ÇÞ|Key_15|ÇÞ|Sort_Key25|ÇÞ|Key_34... (3 Replies)
Discussion started by: PK29
3 Replies

10. UNIX for Beginners Questions & Answers

Matching 2 files based on key

Hi all I have two files I need to match record from first file and second file on column 1,8 and and output only match records on file1 File1: 020059801803180116130926800002090000800231000245204003160000000002000461OUNCE000000350000100152500BM01007W0000 ... (5 Replies)
Discussion started by: arunkumar_mca
5 Replies
TCATEST(1)							   Tokyo Cabinet							TCATEST(1)

NAME
tcamgr - the command line utility of the abstract database API DESCRIPTION
The command `tcamgr' is a utility for test and debugging of the abstract database API and its applications. `name' specifies the name of a database. `key' specifies the key of a record. `value' specifies the value of a record. `params' specifies the tuning parameters. `func' specifies the name of a function. `arg' specifies the arguments of the function. `dest' specifies the path of the destination file. tcamgr create name Create a database file. tcamgr inform name Print miscellaneous information to the standard output. tcamgr put [-sx] [-sep chr] [-dk|-dc|-dai|-dad] name key value Store a record. tcamgr out [-sx] [-sep chr] name key Remove a record. tcamgr get [-sx] [-sep chr] [-px] [-pz] name key Print the value of a record. tcamgr list [-sep chr] [-m num] [-pv] [-px] [-fm str] name Print keys of all records, separated by line feeds. tcamgr optimize name params Optimize a database file. tcamgr misc [-sx] [-sep chr] [-px] name func [arg...] Call a versatile function for miscellaneous operations. tcamgr map [-fm str] name dest Map records into another B+ tree database. tcamgr version Print the version information of Tokyo Cabinet. Options feature the following. -sx : the input data is evaluated as a hexadecimal data string. -sep chr : specify the separator of the input data. -dk : use the function `tcadbputkeep' instead of `tcadbput'. -dc : use the function `tcadbputcat' instead of `tcadbput'. -dai : use the function `tcadbaddint' instead of `tcadbput'. -dad : use the function `tcadbadddouble' instead of `tcadbput'. -px : the output data is converted into a hexadecimal data string. -pz : do not append line feed at the end of the output. -m num : specify the maximum number of the output. -pv : print values of records also. -fm str : specify the prefix of keys. This command returns 0 on success, another on failure. SEE ALSO
tcatest(1), tcamttest(1), tcadb(3), tokyocabinet(3) Man Page 2011-02-12 TCATEST(1)
All times are GMT -4. The time now is 04:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy