10-24-2005
Comm, command help
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 (which is one of the columns) there is overlap when I try to import this into a spreadsheet.
e.g.
col 1 col2 col3
xxxxxxx
------ xxxxxxxxx
--------------yyxxxxxxx
The yy overlaps and is a problem when importing to the spread sheet.
What is needed is a way to define the starting point of each column
of the 'comm' output ?
Any ideas ?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
i have 2 files that contains a sorted list of IP addresses.
file_A contains a list of all IPs
file_B contains only around 50% of what is in file_A.
I tried to execute
comm -23 file_A file_B > file_C
to get the difference. My objective is to put all the IPs that are in file_A but not... (1 Reply)
Discussion started by: tads98
1 Replies
2. Shell Programming and Scripting
Hi
I have issue with "comm " command
file-1
----
l65059
l65407
l68607
l68810
l69143
l71310
l72918
l73146
l73273
l76411
file-2
----- (8 Replies)
Discussion started by: amitrajvarma
8 Replies
3. UNIX for Dummies Questions & Answers
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)
Discussion started by: arunkumar_mca
1 Replies
4. UNIX for Dummies Questions & Answers
could some one please explain with examples how comm -12 & comm -3 works. I am confused with manual page, Thankyou. (2 Replies)
Discussion started by: Ariean
2 Replies
5. Shell Programming and Scripting
I need to compare 2 files. I need to see if 1 file has records that are not in a second file. I did some searching and found the 'comm' command. According to the man pages
comm -23 test1.txt test2.txt
Will tell me what is in file 1 and not in file 2. So I did a simple test
test1.txt has the... (3 Replies)
Discussion started by: guessingo
3 Replies
6. UNIX for Dummies Questions & Answers
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)
Discussion started by: RaviTej
4 Replies
7. Linux
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
8. Shell Programming and Scripting
Hello all ,
I have two files a.txt and b.txt which have same content . They contain data that is fetched from database through a java program. When I delete a line in a.txt and run the below command
comm -13 a.txt b.txt
I am not getting the expected result i.e. the line i deleted from... (5 Replies)
Discussion started by: RaviTej
5 Replies
9. UNIX for Beginners Questions & Answers
Hi,
How can i ignore case between 2 files in unix using COMM command.
2 input files are:
-bash-4.1$ more x2.txt
HELLO
hi
HI
raj
-bash-4.1$ more x3.txt
hello
hi
raj
COMM command:
-bash-4.1$ comm x2.txt x3.txt
hello
HELLO
hi (3 Replies)
Discussion started by: raju2016
3 Replies
10. Shell Programming and Scripting
Given the output below (simplified) extracted from the comparison of two curl -I commands saved in two different files, I am looking for the best approach to highlight the following scenarios in a script:
this header exists only in file1.txt but this one does not
this one exists in both cases... (1 Reply)
Discussion started by: muppets
1 Replies
SDIFF(1) GNU Tools SDIFF(1)
NAME
sdiff - find differences between two files and merge interactively
SYNOPSIS
sdiff -o outfile [options] from-file to-file
DESCRIPTION
The sdiff command merges two files and interactively outputs the results to outfile.
If from-file is a directory and to-file is not, sdiff compares the file in from-file whose file name is that of to-file, and vice versa.
from-file and to-file may not both be directories.
sdiff options begin with -, so normally from-file and to-file may not begin with -. However, -- as an argument by itself treats the
remaining arguments as file names even if they begin with -. You may not use - as an input file.
sdiff without -o (or --output) produces a side-by-side difference. This usage is obsolete; use diff --side-by-side instead.
Options
Below is a summary of all of the options that GNU sdiff accepts. Each option has two equivalent names, one of which is a single letter
preceded by -, and the other of which is a long name preceded by --. Multiple single letter options (unless they take an argument) can be
combined into a single command line argument. Long named options can be abbreviated to any unique prefix of their name.
-a Treat all files as text and compare them line-by-line, even if they do not appear to be text.
-b Ignore changes in amount of white space.
-B Ignore changes that just insert or delete blank lines.
-d Change the algorithm to perhaps find a smaller set of changes. This makes sdiff slower (sometimes much slower).
-H Use heuristics to speed handling of large files that have numerous scattered small changes.
--expand-tabs
Expand tabs to spaces in the output, to preserve the alignment of tabs in the input files.
-i Ignore changes in case; consider upper- and lower-case to be the same.
-I regexp
Ignore changes that just insert or delete lines that match regexp.
--ignore-all-space
Ignore white space when comparing lines.
--ignore-blank-lines
Ignore changes that just insert or delete blank lines.
--ignore-case
Ignore changes in case; consider upper- and lower-case to be the same.
--ignore-matching-lines=regexp
Ignore changes that just insert or delete lines that match regexp.
--ignore-space-change
Ignore changes in amount of white space.
-l
--left-column
Print only the left column of two common lines.
--minimal
Change the algorithm to perhaps find a smaller set of changes. This makes sdiff slower (sometimes much slower).
-o file
--output=file
Put merged output into file. This option is required for merging.
-s
--suppress-common-lines
Do not print common lines.
--speed-large-files
Use heuristics to speed handling of large files that have numerous scattered small changes.
-t Expand tabs to spaces in the output, to preserve the alignment of tabs in the input files.
--text Treat all files as text and compare them line-by-line, even if they do not appear to be text.
-v
--version
Output the version number of sdiff.
-w columns
--width=columns
Use an output width of columns. Note that for historical reasons, this option is -W in diff, -w in sdiff.
-W Ignore horizontal white space when comparing lines. Note that for historical reasons, this option is -w in diff, -W in sdiff.
SEE ALSO
cmp(1), comm(1), diff(1), diff3(1).
DIAGNOSTICS
An exit status of 0 means no differences were found, 1 means some differences were found, and 2 means trouble.
GNU Tools 22sep1993 SDIFF(1)