03-16-2007
Compare 2 flat files
Hi Gurus,
I searched the forum but didnt get much info.
I want to compare 2 files.
1)Newfile comes today with
2)Old file of previous day.
The files are same ,just the new files might have new records sometimes.
So I want to capture these new records in another file.
Can anyone help me in this ??
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a flat file like this
0001 THER ULT HEAD & NECK VES
0002 THER ULTRASOUND OF HEART
0003 THER ULT PERIPHERAL VES
0009 OTHER THERAPEUTIC ULTSND
0010 IMPLANT CHEMOTHERA AGENT
0011 INFUS DROTRECOGIN ALFA
0012 ADM INHAL NITRIC OXIDE
I need to conver this to a comma delimited flat file... (2 Replies)
Discussion started by: thumsup9
2 Replies
2. Shell Programming and Scripting
Hi All,
I am giving an example similar to the problem I have.
I have two data files of 10 columns each in which fields are delimited by comma(,). I need to compare compare the two files using the uniq col(col3). If there are any records in file1 and are not in file2 then I have check the value... (3 Replies)
Discussion started by: rajus19
3 Replies
3. Shell Programming and Scripting
Hi,
I need to compare two flat files (yesterday & today's data) and get only the changed data from flat files. In flat file i dont have data column or anything its just a string data in flat file.Can any one please let me know the script
With Regds
Shashi (3 Replies)
Discussion started by: jtshashidhar
3 Replies
4. Programming
Before i start doing something, I wanted to know whether the approach to compare XML file with UNIX file system structure. I have a pre-configured file(contains a list of paths to executables) and i need to check against the UNIX directory structure. what are the various approches should i use ? I... (6 Replies)
Discussion started by: shafi2all
6 Replies
5. Shell Programming and Scripting
Hi Frnds,
I have a flat file with millions of records. .
Now I on this. (I prefer for AWK as its gives good performance.)
Old_file.txt
------------------
1 gopi ase ....
2 arun pl ...
3 jack sutha ..
4 peter pm ..
...
New_file.txt
---------------
4 peter pm ..
..
... (12 Replies)
Discussion started by: Gopal_Engg
12 Replies
6. Shell Programming and Scripting
Hello,
I am strugling from quite a some time to compare flat files with over 1 million records could anyone please help me.
I want to compare two pipe delimited flat files, file1 with file2 and output the unmatched rows from file2 in file3
Sample File1:
... (9 Replies)
Discussion started by: suhaeb
9 Replies
7. Shell Programming and Scripting
I have four files, I need to compare these files together.
As such i know "sdiff and comm" commands but these commands compare 2 files together. If I use sdiff command then i have to compare each file with other which will increase the codes.
Please suggest if you know some commands whcih can... (6 Replies)
Discussion started by: nehashine
6 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I'm a newbie to scripting and am trying to compare two files using awk.
The files are exactly the same dimensions. Where the first file has 0's I would like to create an updated version of the second file which has the corresponding elements set to zero also.
eg:
file1:
12345 1 2 0... (3 Replies)
Discussion started by: kasan0
3 Replies
9. Shell Programming and Scripting
compare to flat files using awk .but in 4th field contains non ordered substring. how to do that.
file1.txt
john|0.0|4|**:25;JP:50;UY:25
file2.txt
andy|0.0|4|JP:50;**:25;UY:25 (4 Replies)
Discussion started by: veeruasu
4 Replies
10. Shell Programming and Scripting
How to convert this:
F1-R1 F1-R2 F1-R3 into a flat file for bash?? Each record
F2-R1 F2-R2 F2-R3
F3-R1 F3-R2 F3-R3
F4-R1 F4-R2 F4-R3is on one line with all fields for that record, put into an output file. The output file should look like this when converted:
F1-R1,F2-R1,F3-R1,F4-R1... (6 Replies)
Discussion started by: bud1738
6 Replies
LEARN ABOUT SUNOS
acctcms
acctcms(1M) System Administration Commands acctcms(1M)
NAME
acctcms - command summary from process accounting records
SYNOPSIS
/usr/lib/acct/acctcms [ -a [-o] [-p]] [-c] [-j] [-n] [-s] [-t] filename...
DESCRIPTION
acctcms reads one or more filenames, normally in the form described in acct.h(3HEAD). It adds all records for processes that executed iden-
tically named commands, sorts them, and writes them to the standard output, normally using an internal summary format.
OPTIONS
-a Print output in ASCII rather than in the internal summary format. The output includes command name, number of times executed,
total kcore-minutes, total CPU minutes, total real minutes, mean size (in K), mean CPU minutes per invocation, "hog factor," char-
acters transferred, and blocks read and written, as in acctcom(1). Output is normally sorted by total kcore-minutes.
Use the following options only with the -a option:
-o Output a (non-prime) offshift-time-only command summary.
-p Output a prime-time-only command summary.
When -o and -p are used together, a combination prime-time and non-prime-time report is produced. All the output summaries are
total usage except number of times executed, CPU minutes, and real minutes, which are split into prime and non-prime.
-c Sort by total CPU time, rather than total kcore-minutes.
-j Combine all commands invoked only once under "***other".
-n Sort by number of command invocations.
-s Any file names encountered hereafter are already in internal summary format.
-t Process all records as total accounting records. The default internal summary format splits each field into prime and non-prime-
time parts. This option combines the prime and non-prime time parts into a single field that is the total of both, and provides
upward compatibility with old style acctcms internal summary format records.
EXAMPLES
Example 1: Using the acctcms command.
A typical sequence for performing daily command accounting and for maintaining a running total is:
example% acctcms filename ... > today
example% cp total previoustotal
example% acctcms -s today previoustotal > total
example% acctcms -a -s today
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWaccu |
+-----------------------------+-----------------------------+
SEE ALSO
acctcom(1), acct(1M), acctcon(1M), acctmerg(1M), acctprc(1M), acctsh(1M), fwtmp(1M), runacct(1M), acct(2), acct.h(3HEAD), utmpx(4),
attributes(5)
NOTES
Unpredictable output results if -t is used on new style internal summary format files, or if it is not used with old style internal summary
format files.
SunOS 5.10 22 Feb 1999 acctcms(1M)