01-05-2006
Comparing two files (comm or awk) - help - very urgent pls
I an unix newbie and am confused about the working of "comm".
I have two files to be compared and the three columns of output after comparison should be stored a three separate files.
File abc
--------
pink
orange
green
blue
black
maroon
File xyz
---------
pink
yellow
grey
black
blue
maroon
I use :1) comm -23 abc xyz (to get lines unique to abc)
2) comm -13 abc xyz (to get lines unique to xyz)
3) comm -12 abc xyz (to get lines common to both abc and xyz files)
output of 1) is :
--------------
orange
green
blue
black
maroon
output of 2) is:
---------------
yellow
grey
black
blue
maroon
output of 3) is :
---------------
pink (?!?!?)
this is strange to me as i find the lines containing "maroon" is common to both files.. still not pulled out by (3).
Can somebody explain where I missed?
It would be great if help is given on usage of "awk" to do something similar. (In fact, the files I've to compare are much larger than I explained my problem with).
Thanks in advance
Sirisha
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I would be grateful for any assistance in my situation. As a new comer to UNIX, I have tried, but in vain, to search for scripts or methods for this problem.
I need to compare 2 files. A field in the master is to be tested for a match in the slave. Once a match is found, a variable stated... (10 Replies)
Discussion started by: zom_chp
10 Replies
2. Shell Programming and Scripting
Hi,
I am creating a pipe in a directory $HOME/pipes. The pipename should be
L${PROGNAME}. Whenever i embed these lines in shell script, i get an error
mkfifo: No such file or directory.
I am creating a pipe with the key word
mkfifo $HOME/pipes/L${PROGNAME}.
Please help me how to get... (5 Replies)
Discussion started by: raghavan.aero
5 Replies
3. Shell Programming and Scripting
Hi,
I have some text files. I need a separate shell say 1.sh in which i can open a particular text file and compare with another txt file. For example:
1.log.txt contains
apple
ball
cat
goat
2.log.txt contains
goat
cat
lion
apple
fox
In my i.sh i need to write script to... (5 Replies)
Discussion started by: jisha
5 Replies
4. UNIX for Advanced & Expert Users
Hi all,
I am trying to boot a an OS from RAM...(its a opensolaris based distro)
For this i have picked up 2 key lib files that when copied to /tmp and mounted to respective places will do the job..
The sizes of these files combined comes upto 600mb.(i have 2gb ram)
Now i have also located the... (0 Replies)
Discussion started by: wrapster
0 Replies
5. UNIX for Dummies Questions & Answers
Following is d code snipet
#!/bin/ksh
retVal=`sqlplus -s user/passwd\@oracle_sid <<EOF
SET SERVEROUTPUT ON SIZE 100000
DECLARE
STATUS_VALUE VARCHAR2(1);
BEGIN
SELECT temp1 INTO STATUS_VALUE FROM sai;
DBMS_OUTPUT.PUT_LINE(STATUS_VALUE);
END;
/
exit;
EOF`
echo "Return Value... (2 Replies)
Discussion started by: sainathdeg
2 Replies
6. Shell Programming and Scripting
I have downloaded the Putty SSH configuration. I have entered my Host name as illinois.engr.sjsu.edu and i am trying to save that. But i am unable to save.
Also i opened the session and entered my log in name
But it says using keyboard interactive authentication.I am not able to get into $
... (2 Replies)
Discussion started by: VamsiVasili
2 Replies
7. Shell Programming and Scripting
will post again (1 Reply)
Discussion started by: revertback
1 Replies
8. Shell Programming and Scripting
Hi Friends,
Newbie to shell scripting. Currently i have used the below to sort data based on filenames and datestamp
$ printf '%s\n' *.dat* | sort -t. -k3,4
filename_1.dat.20120430.Z
filename_2.dat.20120430.Z
filename_3.dat.20120430.Z
filename_1.dat.20120501.Z
filename_2.dat.20120501.Z... (1 Reply)
Discussion started by: robertbrown624
1 Replies
9. Shell Programming and Scripting
Hi,
These are the text file I have
//input1.txt//
cd dir1/dir2/pg1.txt
cd dir3/dir4/pg2.txt
cd dir88/dir5/pg4.txt
cd dir7/dir6/pg5.txt
cd dir8/dir9/pg7.txt
And each text file has some text.
Now I have to write a shell script which reads input1.txt and changes the directory as shown... (1 Reply)
Discussion started by: bhavanabahety
1 Replies
10. UNIX for Advanced & Expert Users
Hi all,
I have two files as below. I need to compare field 2 of file 1 against field 1 of file 2 and field 5 of file 1 against filed 2 of file 2. If both matches , then create a result file 1 with first file data and if not matches , then create file with first fie data. Please help me in... (1 Reply)
Discussion started by: sivarajb
1 Replies
COMM(1) User Commands COMM(1)
NAME
comm - compare two sorted files line by line
SYNOPSIS
comm [OPTION]... FILE1 FILE2
DESCRIPTION
Compare sorted files FILE1 and FILE2 line by line.
With no options, produce three-column output. Column one contains lines unique to FILE1, column two contains lines unique to FILE2, and
column three contains lines common to both files.
-1 suppress column 1 (lines unique to FILE1)
-2 suppress column 2 (lines unique to FILE2)
-3 suppress column 3 (lines that appear in both files)
--check-order
check that the input is correctly sorted, even if all input lines are pairable
--nocheck-order
do not check that the input is correctly sorted
--output-delimiter=STR
separate columns with STR
--help display this help and exit
--version
output version information and exit
Note, comparisons honor the rules specified by 'LC_COLLATE'.
EXAMPLES
comm -12 file1 file2
Print only lines present in both file1 and file2.
comm -3 file1 file2
Print lines in file1 not in file2, and vice versa.
GNU coreutils online help: <http://www.gnu.org/software/coreutils/> Report comm translation bugs to <http://translationproject.org/team/>
AUTHOR
Written by Richard M. Stallman and David MacKenzie.
COPYRIGHT
Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
join(1), uniq(1)
The full documentation for comm is maintained as a Texinfo manual. If the info and comm programs are properly installed at your site, the
command
info coreutils 'comm invocation'
should give you access to the complete manual.
GNU coreutils 8.22 June 2014 COMM(1)