02-16-2013
Quote:
Originally Posted by
Shenbaga.d
. . .
File_1 contained 4 columns, and File_2 contained 4 columns,
I need to find the difference using 1st column,
Or need to find the difference using 3st column
Quote:
File 1
Code:
1 a
2 b
3 c
4 e
File 2:
Code:
1 e
2 f
3 g
Not sure I understand (or, better: sure I don't understand). You say in post #1, both files have 4 columns, but the files presented have two cols only.
Please be far more clear in specifying your requirements, telling us what comes from where and goes to where based on what conditions. And, be sure to tell rows from columns!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I was wondering what the difference was between the two commands, I understand that locate won't search for files with certain permissions set. Are there any others?
Thanks (1 Reply)
Discussion started by: camerja1
1 Replies
2. Emergency UNIX and Linux Support
I have a file which gets appended with records daily..for eg. 1st day of the month i get 9 records ,2nd day 9 records .....till the last day in the month...the no of records may vary...i store the previous days file in a variable oldfile=PATH/previousdaysfile....i store the current days file in a... (6 Replies)
Discussion started by: ganesh_248
6 Replies
3. Solaris
I need to find the difference between two files in UNIX. I tried diff, but couldn't get it right.
There are two files:
file1: apple
mango
strawberry
banana
grape
file2: grape
apple
banana
I need an output file like below: ... (11 Replies)
Discussion started by: kisaad
11 Replies
4. UNIX for Dummies Questions & Answers
I have two files as below
File1:
a
b
c
d
File2:
a
b
When i find the difference the output would be c&d..
How can i get my requirement...pls help...
Many thanks in advance (10 Replies)
Discussion started by: jagadish_gaddam
10 Replies
5. UNIX for Advanced & Expert Users
I have 2 files as follows.
file1.txt
<cell>123</cell>
<cell>345</cell>
file2.txt
<cell>123</cell>
<cell>456</cell>
out out should be
output.txt
<cell>456></cell>
How do we achieve this> The difference betwenn the two files should be wirtten to the output file..
... (2 Replies)
Discussion started by: kanthrajgowda
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
What is the difference between these two?
find /some_dir -type f -exec chmod 070 {} \;
and
chmod 070 `find /some_dir -type f`
Thanks (5 Replies)
Discussion started by: lamont
5 Replies
7. Shell Programming and Scripting
Hi,
The requirement is to compare two files that has single column of records each. Comparison is to happen on a whole and not line by line.
File1.txt
314589929
315611087
304924413
315989094
301171509
302984393
315609549
314593632
File2.txt
315611087
304924413
315989094 (2 Replies)
Discussion started by: anandek
2 Replies
8. Shell Programming and Scripting
I have a file wich contains time formats and i need to get the time difference
TIME1 TIME2
==================================
20120624192555.6Z 20120624204006.5Z
which means first date 2012/6/24 19:25:55,second date 2012/6/24 20:40:06 so when i get the time... (1 Reply)
Discussion started by: wnaguib
1 Replies
9. UNIX for Dummies Questions & Answers
I have a file wich contains time formats and i need to get the time difference
TIME1 TIME2
=============== ===================
20120624192555.6Z 20120624204006.5Z
which means first date 2012/6/24 19:25:55,second date 2012/6/24 20:40:06 so when i get the time... (23 Replies)
Discussion started by: wnaguib
23 Replies
10. Shell Programming and Scripting
Hi All,
Please find my problem below:
I have a file at two different nodes dev and test
1st find> find /u/dev/local/abc -name ab.dat
--Since this file can be in several sub directories
2nd find> find /u/test/local/abc -name ab.dat
I find my 1st find result and do compare with 2nd... (5 Replies)
Discussion started by: varun_bharadwaj
5 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)