Differences between 2 Flat Files and process the differences
Hey Guru
Sorry for the confusion but
what I meant to ask was that
Code:
'NR==FNR{a[i++]=$1" "$2" "$3" "$4;next;}
by this you store first 4 columns of the whole file(all rows)
and then you move to the next
Code:
{x=$1" "$2" "$3" "$4; for (j in a){if (a[j] == x)next;}}1'
where you store the first 4 columns of each row of second file in x and compare them against the all rows(but first 4 columns only) one by one
what does this 1' means and after executing this awk script the final
file that we will have only 4 columns or the whole structure of the file
(it should compare only the first 4 columns but in the final file should have all 6 columns)
Thanks
J
Moderator's Comments:
Please use code tags.
Last edited by Scott; 07-17-2010 at 01:53 PM..
Reason: Code tags
Hi,
"diff" command takes two file names as arguements and gives the difference between the two.
How do I get the number of differences between two files ???
(Excluding whitespaces).
Don't ask me to count number of lines produced by "diff".
Thanks in advance,
Sharath (4 Replies)
All,
I have two csv files, the format of which are exactly the same.
I would like to find differences between the two files but would like to identify the difference as opposed to just printing a different line.
For exmaple
File 1
xxx,yyy,zzz,1,2,3
111,222,333,xxx,yyy
... (4 Replies)
Hello, I'm having trouble to read two txt files, they have employee records line by line, I need to do the reading of a file that is old and compare it with the new base in the new file, deleting the lines in old file, then add the new file data from the old file and write to the database manager.... (5 Replies)
Hi everyone,
I know that's a deep treated issue but I'm actually not able to find the solution. I have 2 plain text files with ~ 2000 rows and ~5 columns. The first column of the shortest file (f1) is fully contained by the first column of the biggest one (f2), but only that column. I want to... (6 Replies)
Hi,
I'm trying to create a script to catch a process which is consuming high CPU which I have pretty much done but it's just finding the correct place to pull the current CPU for that process.
When viewed in Topas it's consuming 99.*% cpu
But if I try using
ps avg or ps -eo pcpu
... (5 Replies)
Hi
*
I have two text files which has the file size, timestamp and the file name. I need to compare these two files and get the differences in the output format. Can anyone help me out with this.
*
cat file1.txt
*474742 Apr 18* 2010 sample.log
*135098 Apr 18* 2010 Testfile
134282 Apr 18* 2010... (7 Replies)
I have 2 files that need to be compared. Email the differences if something is different and don't email if nothing is different. One or both of the files could be empty. One or both could have data in them.
example files
backup.doc.$(date +%y%m%d) file size is 0
backup.doc.$(TZ=CST+24... (4 Replies)
Hello All,
Requirement is to compare 2 XML files and see if there are any differences but from some of the providers We are receiving UTF-16 formatted XML file with no end of line as shown below.
Excerpt of data file:
ÿþ<^@?^@x^@m^@l^@ ^@v^@e^@r^@s^@i^@o^@n^@=^@"^@1^@.^@0^@"^@... (11 Replies)
Discussion started by: Ariean
11 Replies
LEARN ABOUT OSF1
dxdiff
dxdiff(1X)dxdiff(1X)NAME
dxdiff - Motif visual differences program
SYNOPSIS
dxdiff [options] [file1 file2]
OPTIONS
Specifies the color of the window's border (color displays only). The default is black. Specifies the color of the window's background
(color displays only). The default is white. Specifies the display screen where dxdiff displays its window. If the display option is not
specified, dxdiff uses the display screen specified by your DISPLAY environment variable. The display option has the format hostname:num-
ber. Using two colons (::) instead of one (:) indicates that DECnet is to be used for transport. The default is :0. For more information,
see X(1X). This option is the same as the -d option. Specifies the color of the text (color displays only). The default is black. Spec-
ifies the font used as the output font. The default font is times_bold12. Specifies the width, length, and location of the dxdiff window.
If the geometry option is not specified, dxdiff uses default values. The geometry option has the format [widthxlength][{+-}x{+-}y]. For
more information about the screen coordinate system, see X(1X). Disables linked vertical scrolling. Enables linked vertical scrolling.
This is the default. Disables linked horizontal scrolling Enables linked horizontal scrolling. This is the default. Enables the display
of filled polygons to connect areas of different text. This is the default. Enables the display of lines to connect areas of different
text. Disables the display of line numbers in the difference region. Enables the display of line numbers in the difference region. This
is the default. Specifies the foreground color for the line numbers in the difference box. The default is black.
OPERANDS
Specifies the two files that are to be opened at startup. If you do not specify any file names, dxdiff lets you specify files after it has
started up.
DESCRIPTION
The dxdiff application does a line-by-line comparison of two files and displays the differences between them. The contents of the two files
are displayed in two text regions on either side of a central difference region. The differences between the files are displayed as high-
lighted text. The differences are connected by lines or filled polygons across the central difference region. Line numbers are optionally
displayed at each end of the difference lines, to show where the differences occur within the files. Note that the files must be ASCII text
files.
MENUS
The dxdiff window contains the following menus: File Options Differences Help
File Menu
The dxdiff File menu contains the following menu items: Calls up two Open... dialog boxes, to allow you to specify the two files that you
want to compare. The dialog boxes are labeled Left File and Right File. You must select one file from each dialog box. Exits the current
dxdiff session. If the session is the original one, all other dxdiff sessions and windows are closed.
Options Menu
The Options menu contains the following menu items: The default is linked vertical scrolling. When linked vertical scrolling is on and you
scroll one of the files, the other file is scrolled with it line for line. When linked vertical scrolling is off, one file can be scrolled
independently of the other one. The default is linked horizontal scrolling. When linked horizontal scrolling is on and you scroll one of
the files, the other file is scrolled with it. When linked horizontal scrolling is off, one file can be scrolled independently of the
other one. Displays either lines or filled polygons to connect the differences across the difference box. The default on startup is for
filled polygons to be displayed. Displays line numbers at each end of the lines that connect the differences. The default is to display
line numbers. If dxdiff cannot find a suitable font size for displaying the line numbers, this item is disabled.
Differences Menu
The Differences menu contains the following items: Displays the differences between the two currently selected files. Opens a new dxdiff
window to display the differences between the two currently selected files. The existing dxdiff window remains on the screen for refer-
ence.
Help Menu
The Help Menu button invokes a help window that provides information on dxdiff.
X DEFAULTS
The dxdiff application uses the values in the file when you logged in and uses the appropriate resource specification to customize the
appearance or characteristics of its displayed dxdiff window. The format for a resource specification in the file is:
[*name*]resource: value
Specifies the application name or the name string that restricts the resource assignment to that application or to a component of an appli-
cation. If this argument is not specified, the resource assignment is globally available to all X applications. Specifies the resource.
Specifies the value that is to be assigned to the resource.
For more information, see X(1X).
Because each toolkit-based application can consist of a combination of widgets (for example, push buttons and a scroll bar), you can form
the name string by adding widget class and name identifiers to the string. For further information about adding class and name identifiers,
see X(1X).
For dxdiff, the available class identifiers are: XmLabel XmPushButton XmRowColumn XmScrollbar XmText
For dxdiff, the available name identifiers are: The application class name The application name The entire display, which includes all of
the components of the window The main menu bar, which includes the pull-down menus The file selection dialog box for selecting a file to be
displayed in the left text display region The file selection dialog box for selecting a file to be displayed in the right text display
region The File pull-down menu The Open button on the File menu The Exit button on the File menu The Options pull-down menu The Linked Ver-
tical Scrolling On/Off button on the Options menu The Linked Horizontal Scrolling On/Off button on the Options menu The Display Diffs As
Lines/Filled Polygons button on the Options menu The Display Line Numbers button on the Options menu The Differences pull-down menu The Do
Differences button on the Differences menu The Do Differences In New button on the Differences menu The text region display, which includes
both the left and the right text display regions, each of which include the file name bars, the vertical scroll bars, the push button
region and the text panes The region where the lines connecting the differences are displayed The file name bars at the top of each text
region The vertical scroll bars The region where the file contents are displayed The push button region at the bottom of each text display
region The Next Diff push button The Prev Diff push button
In addition to the general resources listed in X(1X), the resources available for dxdiff are: Enable or disable linked vertical scrolling.
The default is on. Enable or disable linked horizontal scrolling. The default is on. Enable or disable display of line numbers in the
difference region. The default is on. Enable or disable use of lines to connect areas of different text. The default is off. If drawing of
lines is disabled, filled polygons are used. Specify the foreground color for line numbers in the difference box.
EXAMPLES
To change the background color of the dxdiff text regions, add the following entry to your file:
dxdiff*textdisplay*background: blue To change the background color of the push button region at the bottom of the window, add the
following entry to your file:
dxdiff*displaymenu*background: red
FILES SEE ALSO diff(1), mwm(1X), X(1X)dxdiff(1X)
07-17-2010
