I have two large (similar) files that have a unique number in the first column...(the trade id) and then a value for that trade in the second column...delimited by "~". Here is a snippet of what the files look like
For some reason IDs that are only unique to one of the files are creeping into the final output...
I can write a workaround (which will be longer and messier as I am pretty new to this) however if anyone can suggest a way of matching the fields on the tradeIds but omitting ones that are in one file and not the other it will be forever grateful!!
Thanks
Kevin
Last edited by Scott; 05-08-2011 at 01:11 PM..
Reason: Please use code tags
Hi, I'm having the following problem with the unix sdiff command.
for example if I try sdiff <filename 1> <filename 2>
Where filename 1 and filename 2 contain really long pathnames that I need to compare.
The output I get will be 139 characters long which is the default.
But an output of... (0 Replies)
Hello,
I'm using Sdiff to compare 2 files, I've used this before and it works fine
and still does in some cases.
But it seems to trip up when using combinations of alpha-numeric text.
I created two simple files to test and as you can see it seems to trip up
on the "gr55a" text, any ideas ?
... (2 Replies)
Hi all
I have two files which are essentially the same. However the way an exponent is written is different (i.e. in 1 file, a particular number might be written as 1.43230000E+02 whereas in another it might be 1.4323E2).
If I use SDIFF then the program will merely check the ASCII characters... (1 Reply)
Hi there,
I am hoping someone can help!
I am doing a simple difference between two files using the sdiff command..
sdiff -s file1 file2
this works, but for some words it doesn't...
Here is an example:
fha 2B01 fha 2B01
fmaa 3A01 fmaa 3A01
fox 4A46 | fmx 3A01
... (1 Reply)
Hi,
I'm trying to use sdiff by parsing the output of another command instead of the filename:
sdiff <(echo test1) <(echo test2)However, this seems to cause my terminal session to stop working.
If I use it with normal diff it works fine:
~$ diff <(echo test1) <(echo test2)
1c1
< test1... (4 Replies)
Hi
i am comparing file on 2 different machine with the help of script.
however i am get below o/p
======= /usr/tmp =========
======= /usr/tmp not a regular file i am not sure what does "not a regular file mean" .
is it something serious, if yes then what i need to check or we can... (1 Reply)
Hello guys,
I have a problem. I'm trying to use SDiff with two files which are containing spaces.
My problem is that I want to save the output with > in an extra file.
If I try to use it like this.
sdiff "test file1" "test file2" > OutputfileI get this message:
usage: diff ... (11 Replies)
Update:
Last two days the number of users on the site has peaked (normally around 10AM US Eastern Time) between 4,300 and 4,500.
This is the highest number of consistent concurrent users in at least 3 years.
... and the traffic continues to rise week-over-week. (5 Replies)
sdiff(1) User Commands sdiff(1)NAME
sdiff - print differences between two files side-by-side
SYNOPSIS
sdiff [-l] [-s] [-o output] [-w n] filename1 filename2
DESCRIPTION
sdiff uses the output of the diff command to produce a side-by-side listing of two files indicating lines that are different. Lines of the
two files are printed with a blank gutter between them if the lines are identical, a < in the gutter if the line appears only in filename1,
a > in the gutter if the line appears only in filename2, and a | for lines that are different. (See the EXAMPLES section below.)
OPTIONS -l Print only the left side of any lines that are identical.to
-s Do not print identical lines.
-o output Use the argument output as the name of a third file that is created as a user-controlled merge of filename1 and filename2.
Identical lines of filename1 and filename2 are copied to output. Sets of differences, as produced by diff, are printed; where
a set of differences share a common gutter character. After printing each set of differences, sdiff prompts the user with a %
and waits for one of the following user-typed commands:
l Append the left column to the output file.
r Append the right column to the output file.
s Turn on silent mode; do not print identical lines.
v Turn off silent mode.
e l Call the editor with the left column.
e r Call the editor with the right column.
e b Call the editor with the concatenation of left and right.
e Call the editor with a zero length file.
q Exit from the program.
On exit from the editor, the resulting file is concatenated to the end of the output file.
-w n Use the argument n as the width of the output line. The default line length is 130 characters.
USAGE
See largefile(5) for the description of the behavior of sdiff when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).
EXAMPLES
Example 1 An example of the sdiff command.
A sample output of sdiff follows.
x | y
a a
b <
c <
d d
> c
ENVIRONMENT VARIABLES
If any of the LC_* variables ( LC_CTYPE, LC_MESSAGES, LC_TIME, LC_COLLATE, LC_NUMERIC, and LC_MONETARY ) (see environ(5)) are not set in
the environment, the operational behavior of sdiff for each corresponding locale category is determined by the value of the LANG environ-
ment variable. If LC_ALL is set, its contents are used to override both the LANG and the other LC_* variables. If none of the above vari-
ables is set in the environment, the "C" locale determines how sdiff behaves.
LC_CTYPE Determines how sdiff handles characters. When LC_CTYPE is set to a valid value, sdiff can display and handle text and file-
names containing valid characters for that locale.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------------------------------------+
|ATTRIBUTE TYPE ATTRIBUTE VALUE |
|Availability SUNWesu |
|CSI Enabled |
+-----------------------------------------------------------+
SEE ALSO diff(1), ed(1), attributes(5), environ(5), largefile(5)SunOS 5.11 20 Dec 1996 sdiff(1)