10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
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
2. Shell Programming and Scripting
I am trying to look for $2 of file1 (skipping the header) in $2 of file2 (skipping the header) and if they match and the value in $10 is > 30 and $11 is > 49, then print the line from file1 to a output file. If no match is foung the line is not printed. Both the input and output are tab-delimited.... (3 Replies)
Discussion started by: cmccabe
3 Replies
3. Shell Programming and Scripting
Trying to match $5 of file1.txt to $1 of file2.txt and if there is a match copy $6 of file2.txt and paste it to $7 of file1.txt. My attempt is below but it does not seem to produce the desired output. Thank you :).
awk 'NR==FNR{A=$1; next} A {$6=$6 " " A}1' file2.txt file1.txt >... (2 Replies)
Discussion started by: cmccabe
2 Replies
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
Trying to match the text from file1 to file2 and print what matches in a new file (match.txt) and what does not in another (missing.txt).
awk -F'|' 'NR==FNR{c++;next};c > 0' flugent.txt IDT.txt > match.txt
Thank you :). (8 Replies)
Discussion started by: cmccabe
8 Replies
6. Shell Programming and Scripting
grep -f genes.txt refseq_exons.txt
grep -wFf genes.txt refseq_exons.txt > output.txt
awk 'FNR==NR {a; next} $1 in a' genes.txt refseq_exons.txt > output.txt
The above seem to match the records but not all of them and I'm not sure why., I am just trying to match the gene name in genes.txt to... (3 Replies)
Discussion started by: cmccabe
3 Replies
7. Shell Programming and Scripting
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| ... (4 Replies)
Discussion started by: raj_k
4 Replies
8. Shell Programming and Scripting
Hello ALL,
Hope all fine for you.
I have the following task but no idea about how to do.
I have 2 files (ascii)
one of them is a list of bib records, looks like this:
=LDR 01228nam 2200301 b 4500
=001 00000000000001
=005 20090429:10082000
=008 ... (2 Replies)
Discussion started by: ldiaz2106
2 Replies
9. Shell Programming and Scripting
Hi,
I have many files named CCR20110720011001.CTRD
CCR20110720011501.CTRD
CCR20110720012001.CTRD
CCR20110720012501.CTRD
CCR20110720021001.CTRD
... (9 Replies)
Discussion started by: shadyfright
9 Replies
10. Shell Programming and Scripting
Hi all please give me the solution for this im stuck somewhere.
I have two files A and B
file A has 300 records as
000.aud
111.aud
.
.
.
300.aud
file B has 213 records randomly
005.aud
176.aud
.
.
.
200.aud
I want to match similar 213 records in file B from file A. (2 Replies)
Discussion started by: Haque123
2 Replies