07-15-2013
Comparing two files and generating the report
Hi All,
What am trying to do is generate the report by compating two files.
File A
-----------
111 22222 3333
222 55555 7777
File B
-----------
11A 22222 3333
333 55555 7778
Now the report should be as follows
Added:
333 55555 7778
Removed:
222 55555 7777
Modified
111 22222 3333
I have tried using the diff and comm command, the issue am facing is in getting the modified record, by using comm -23 and comm -13 , I am able to get the individual records which are added or removed (Same result using the grep -Fvf file1 file2 and grep -Fvf file2 file1).
So kindly advise how can I get the modified record
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I've been working on getting a script to take size, dir name and file name variables from an input file and creating the same dir structure along with the file of specific size.
An example of the input file:
size/dirname/filename
2100/JAN_06/12345ABC.TCC
2354/FEB_06/24564XYZ.NOS... (2 Replies)
Discussion started by: nxd25
2 Replies
2. Shell Programming and Scripting
Hi,
My aim is to generate a report using shell script. There are various formats fields coloumns etc.
I want to print in a single line (row) but in different coloumn as given below:
field1 field2 field3 field4
....... ....... ...... .......
The spacing... (1 Reply)
Discussion started by: jisha
1 Replies
3. Shell Programming and Scripting
I/P file name:- 20092008.txt
Check number of entries in i/p file by following command
ChkEnt -infl 20092008.txt -opfl 20092008_test.txt >count.txt
Dear Friends,
Please help me in automating following thing.
If output generated (count.txt) is having value more than 1000 i.e.... (8 Replies)
Discussion started by: anushree.a
8 Replies
4. Shell Programming and Scripting
My file will contain following(log.txt):
start testcase: config loading
......
error XXXX
.....
end testcase: config loading, result failed
start testcase: ping check
.....
error ZZZZZ
.....
error AAAAA
end testcase: Ping check, result failed
I am expecting below output. ... (4 Replies)
Discussion started by: shellscripter
4 Replies
5. Shell Programming and Scripting
Hi all,
I have a log file of the below format.
20081016:000042 asdflasjdf asljfljs asdflasjf safjl
20081016:000229 /lask/ajlsdf/askdfjsa
20081016:000229 /lashflas /askdfaslj hsfhsahf
20081016:000304 lasflasj ashfashd
20081016:000304 lajfasdf ashfashdfhs
I need to generate a... (3 Replies)
Discussion started by: manoj.naidu
3 Replies
6. Shell Programming and Scripting
Hi,
I want to generate a report for count mismatching.
Steps followed for creating a script
for file in
1). I have to fetch the file name from the checksum.out #customer_information_
2). Added Detail #customer_information_Detail
3). Check the file exist or not.
3.1.1)if the the file... (1 Reply)
Discussion started by: number10
1 Replies
7. Shell Programming and Scripting
On my website I host a lot of files, and when people view the site, currently each time the page loads, I have PHP generating the md5 sums for the files right then and there. It was fine when my site was small, but now that's obviously very inefficient. Now I'd like to start generating MD5 sums... (4 Replies)
Discussion started by: GrdLock
4 Replies
8. Shell Programming and Scripting
Hello All,
I need to execute around 15 queries after which all data should come in Excel format.
Executing 15 queries is not a problem.
Problem is how to present/put data in excel.
kindly suggest me how to start, what to study or what should i do.
thanks, (1 Reply)
Discussion started by: shubham8787
1 Replies
9. Shell Programming and Scripting
Hi I recently joined a project where I have been asked to generate a report using shell script accessing UNIX box.
I have no idea on how to do it as I am a beginner and learning shell scripts.
Suppose I have a XML:
<XYZRequest>
<effectiveDate>someDate</effectiveDate>... (2 Replies)
Discussion started by: vat1kor
2 Replies
10. Shell Programming and Scripting
Comparing two files on row by row
File1
ecount~100
dcount~200
ccount~300
zxcscount~5000
and so on.
File2
ecount~100
dcount~203
ccount~300
zxcscount~5000
and so on.
If i use diff command (1 Reply)
Discussion started by: onesuri
1 Replies
sa2(8) BSD System Manager's Manual sa2(8)
NAME
sa2 -- Generate a system activity daily report file.
SYNOPSIS
/usr/lib/sa/sa2 [-dgpu] [-n mode] [-e time] [-f filename] [-i seconds] [-s time]
DESCRIPTION
The sa2 command is a shell script used to invoke the system activity reporter sar for purposes of generating the standard default daily
report file. The report file generated is, /var/log/sa/sardd where the dd represents the current day of the month. The sa2 options are the
same as those documented in sar(1).
When sa2 runs, it will also remove data and report files, found in /var/log/sa, that are more than one week old.
The sa2 command is intended to be started by cron.
EXAMPLE CRON ENTRY
# Starting at 8am collect system activity records
# every 20 minutes for 12 hours
# 20 minutes = 1200 seconds
# 12 hours with 3 samples each hour = 36 loops
0 8 * * 1-5 /usr/lib/sa/sa1 1200 36
# After the 12 hour period,
# collect a system activity report
30 20 * * 1-5 /usr/lib/sa/sa2 -A
FILES
/var/log/sa/sardd Default daily report file.
/var/log/sa/sadd Default daily data file.
dd are digits that represent the day of the month.
SEE ALSO
crontab(1), fs_usage(1), netstat(1), sar(1), sc_usage(1), top(1), vm_stat(1), crontab(5), iostat(8), sa1(8), sadc(8)
Mac OS X Jul 25 2003 Mac OS X