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 DEBIAN
xvier
XVIER(6) Games Manual XVIER(6)NAME
xvier - a X11 board game.
SYNOPSIS
xvier [ -display displayname ] [ -geometry geometry ] [ -fn fontpattern ] [ -iconic ] [ -rows rows ] [ -columns columns ] [ -prog program-
path ] [ -level levelnumber ]
DESCRIPTION
Xvier is a board game where you and the computer alternately throw stones into free columns. The stones pile up in the columns, and the
goal is to get four stones in a row, in a column or diagonally. You can choose various board sizes and levels of difficulty.
During the game you click with the mouse onto the column where you want to put your stone. Another possibility is a lower case letter in
the range 'a' to 'm' (maximally) where 'a' is the left column. If you want to change the level of difficulty, you must use the keyboard.
Simply type the number of the desired level. These levels correspond to the search depth of the game program. The meaning of the command
line options and buttons is given below.
While the game program computes a move, everything besides Change and Quit is blocked.
OPTIONS -display displayname
The X11 screen you want to use.
-geometry geometry
The desired geometry of the game window.
-fn fontpattern
A pattern describing the fonts which are used for the buttons and messages. Xvier chooses the biggest font that fits into the win-
dow. Therefore the pattern should describe different sizes of one font. The default is *-Helvetica-Medium-R-Normal-*.
-iconic
Start in iconic state.
-rows rows
The number of rows of the board. The possible range is 4 to 13. The default is 6.
-columns columns
The number of columns of the board. The possible range is 4 to 13. The default is 7.
-prog programpath
The path of the game program.
-level levelnumber
The level of difficulty to start with. The possible range is 0 to 9. The default is 0.
BUTTONS
The keyboard equivalents of the buttons are given in brackets.
Quit ['q' or 'Q'] Finish the game.
New ['n' or 'N'] Start a new game.
Undo ['u' or 'U'] Undo one move.
Start ['s' or 'S'] Let the computer begin with the first move. The board must be empty.
Change ['C'] Exchange the colours of your and the computer's stones.
AUTHOR
Norbert Jung jung@dia.informatik.uni-stuttgart.de
21 April 1992 XVIER(6)
07-17-2010
