The combination of bash and comm on Solaris 10 seems to work:
Code:
#!/usr/bin/env bash
# @(#) s1 Demonstrate results from comm.
# ____
# /
# | Infrastructure BEGIN
echo
set -o nounset
debug=":"
debug="echo"
## The shebang using "env" line is designed for portability. For
# higher security, use:
#
# #!/bin/sh -
## Use local command version for the commands in this demonstration.
set +o nounset
echo "(Versions displayed with local utility \"version\")"
version >/dev/null 2>&1 && version =o $(_eat $0 $1) comm
set -o nounset
echo
FILE1=data1
echo " Input file $FILE1:"
cat $FILE1
echo
FILE2=data2
echo " Input file $FILE2:"
cat $FILE2
# | Infrastructure END
# \
# ---
echo
echo " Results from processing:"
comm -23 $FILE1 $FILE2
exit 0
Producing
Code:
$ ./s1
(Versions displayed with local utility "version")
SunOS 5.10
GNU bash 3.00.16
comm - no version provided for /usr/bin/comm.
Input file data1:
CSCeb69473
CSCsg70355
CSCsj78917
CSCsj85065
CSCsl48743
CSCsl72823
CSCsl77748
Input file data2:
CSCsg39295
CSCsj78917
CSCsj85065
CSCsl72823
CSCsl77748
Results from processing:
CSCeb69473
CSCsg70355
CSCsl48743
The same results were obtained on Linux 2.6.11 (Debian).
I would next look at the data so see if there are extra non-printing characters ... cheers, drl
Hi,
I have two large files with uid's:
- 581004 File1.txt
- 292675 File2.txt
I want to know which uid's are in File1.txt and not in File2.txt.
I have used comm -23 File1.txt File2.txt. This should do the trick i thought. But in the output i keep having uid's in File1.txt that are also in... (8 Replies)
Hello all, I have two flat files that are colon delineated and I am trying to run a compare (Solaris v8 ksh) of $1 within a script to access a mysql database based on the results. Unix is telling me that it has to have physical file names. Is there a way to run a compare using variables? This is... (3 Replies)
See my other post on sdiff ....
I don't think sdiff is able to do what I want.
The 'comm' command does what I need and works fine as
far as the logic and results.
The problem I'm having is with the output format, it outputs 3 columns of data,
but because of the way it starts each line... (2 Replies)
I have two sorted files.
newfile has records like:
aaa|bbb|ccc|||
ddd||eee|fff||
oldfile has records like:
aaa|bbb|ccc|
ggg||hhh|fff
The output should like:
ddd||eee|fff||
I use comm but it's not working for this case.
comm -2 -3 newfile oldfile > difffile
The difffile is the... (6 Replies)
hi,
I have two unsorted files and want to delete the lines which are common to both.
file 1:
S1069656304010437
S1069656304010449
S1470204501005393
S1069656304010474
S0001209208001294
S0000000012345678
S0001457507000590
S0002641707000784
S1470204501005381
S0001457507000280... (4 Replies)
Hi all,
I need help in comm command , I am having 2 files . I have to display the common line in the two file only onnce and i have to also display the non common line as well.
tmpcut1 -- First file
cat tmpcut1
smstr_303000_O_432830_... f_c2_queue_sys30.sys30 RUNNING 10 1000... (1 Reply)
Hello , I am trying to get contents which are only present in a.csv ,so using comm -23
cat a.csv | sort > a.csv
cat b.csv | sort > b.csv
comm -23 a.csv b.csv > c.csv.
a.csv
SKU COUNTRY CURRENCY PRICE_LIST_TYPE LIST_PRICE_EFFECTIVE_DATE
TG430ZA ZA USD DF ... (4 Replies)
The manual does not cover this very well. What do the following compares will do ?
1) comm -13 file1 file2: will it display what is in file2 not in file1?
2) comm -23 file1 file2: will it display what in 1 but not in 2 ?
Thanks (5 Replies)
Discussion started by: mrn6430
5 Replies
LEARN ABOUT OPENSOLARIS
comm
comm(1) User Commands comm(1)NAME
comm - select or reject lines common to two files
SYNOPSIS
comm [-123] file1 file2
DESCRIPTION
The comm utility reads file1 and file2, which must be ordered in the current collating sequence, and produces three text columns as output:
lines only in file1; lines only in file2; and lines in both files.
If the input files were ordered according to the collating sequence of the current locale, the lines written will be in the collating
sequence of the original lines. If not, the results are unspecified.
OPTIONS
The following options are supported:
-1 Suppresses the output column of lines unique to file1.
-2 Suppresses the output column of lines unique to file2.
-3 Suppresses the output column of lines duplicated in file1 and file2.
OPERANDS
The following operands are supported:
file1 A path name of the first file to be compared. If file1 is -, the standard input is used.
file2 A path name of the second file to be compared. If file2 is -, the standard input is used.
USAGE
See largefile(5) for the description of the behavior of comm when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).
EXAMPLES
Example 1 Printing a list of utilities specified by files
If file1, file2, and file3 each contain a sorted list of utilities, the command
example% comm -23 file1 file2 | comm -23 - file3
prints a list of utilities in file1 not specified by either of the other files. The entry:
example% comm -12 file1 file2 | comm -12 - file3
prints a list of utilities specified by all three files. And the entry:
example% comm -12 file2 file3 | comm -23 -file1
prints a list of utilities specified by both file2 and file3, but not specified in file1.
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of comm: LANG, LC_ALL, LC_COLLATE,
LC_CTYPE, LC_MESSAGES, and NLSPATH.
EXIT STATUS
The following exit values are returned:
0 All input files were successfully output as specified.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesu |
+-----------------------------+-----------------------------+
|CSI |enabled |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO cmp(1), diff(1), sort(1), uniq(1), attributes(5), environ(5), largefile(5), standards(5)SunOS 5.11 3 Mar 2004 comm(1)