01-29-2009
Match two files
Hi, can any one please assist me, I tried doing diff file1 file2, but does not get the require output.
File1:
apple
mango
peas
File2:
carrot
mango
apple
123
Q. Match the two files such that, if any word present in file1, for ex peas, does not matches to file2 then it should go to file3, and similarly if any word present in file2, for ex carrot, does not matches to file1 then it should go to file4. Note that the words are random.
Result expected:
File3:
peas
File4:
carrot
123
File5(match):
apple
mango
Thankyou.
10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
LEARN ABOUT DEBIAN
mencal
mencal(1) 1 mencal(1)
NAME
mencal - menstruation calendar
SYNOPSIS
mencal [options] [file1 file2 ... -c CONF1 -c CONF2 ...]
DESCRIPTION
Display options:
-m, --monday
draw monday as first weekday (sunday is default)
-1 current month (default)
-3 previous, current and next month
-y [YYYY]
all-year calendar (default YYYY is current year)
-q, --quiet
no top information will be printed
-n, --nocolor
noncolored output
-i, --icolor COLOR
intersection color (default red)
available colors: red, green, blue, yellow, violet, cyan, shiny, bold
mencal configuration:
-c, --config
s=[YYYY]MMDD,l=LL,d=DD,n=NAME,f=FILE,c=COLOR
The second argument is a comma separated list of options. No spaces are allowed in this list. If no name is specified, 'Unknown' is
used. Various -c options or filenames can be set.
s,start=[YYYY]MMDD
start day of period (default current day)
l,length=LL
length of period in days (default 28)
d,duration=D
duration of menstruation in days (default 4)
n,name=NAME
name of subject
f,file=FILE
filename to save configuration to (see section FILES)
only menstruation related variables will be saved
c,color=COLOR
color used for menstruation days
available colors: red, green, blue, yellow, violet, cyan, shiny, bold default color is red, with '-n' switch color settings are
ignored
Info options:
-h, --help
print help
-V, --version
print version information
FILES
:
$HOME/.mencalrc - the default configuration file that is automatically loaded
AUTHOR
:
(C) 2002 C. McCohy
e-mail: <mccohy@kyberdigi.cz>
Word-Wide-Web: http://www.kyberdigi.cz/projects/mencal/english
This manual page was written for the Debian GNU/Linux distribution because the original program does not have a manual page (but may be
used by others).
HISTORY
22 March 2002 - Originally written by Amaya Rodrigo <amaya@debian.org>.
24 Apr 2002 - New manpage contributed by Pablo S. Torralba <psanchez@skyrealms.org>.
Amaya Rodrigo <amaya@debian.org> is now responsible for developing and maintaining this manual page. Comments and suggestions are greatly
wellcome.
mencal Menstruation calendar mencal(1)