lat week I was able to get some assistance on creating a summary report from a file generated by a "comm" comparison of twp CSV files...turn out now that I am being asked for a detail report as well...this is beyond my knowledge of perl (and yes I have to use perl)..also please keep in mind that the setup where I work does not have any fancy modules to use and they will not installed them..been there and tried...so it must be a script...here's the background and what I am looking to do...hope you can assist...
So here's the background:
I am suppose to compare a database before and after and report the changes accordingly.
This database conatines "RULES" (the id field) we used for transmitting files.
So I have a MySQl table called lsof_conf which I dump as a CSV into file fuss_lsof_conf.txt.
The pretence is that after it's dumped someone will be making changes to the table via MySQL.
These changes can include adding a new record, deleteing a record and finally altering one of 7 fields.
The table fields are:
id, t_client, t_filelocation, t_remotescript, t_destination, t_enabled, t_search, t_compression
So now my script will run again dump the lsof_conf table again as a CSV into file fuss_lsof_conf2.txt.
Now I have two files that I use to compare to each other.
File1: fuss_lsof_conf.txt
File2: fuss_lsof_conf2.txt
From this I create a differnce file using the "diff" command and the output is diff_fuss_file.txt.
Sample data:
File fuss_lsof_conf.txt contains:
28,gmp,/ureports/ibgmp/pcd/rpts/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/pcd/rpts/fiche,YES,<where><any><yesterday><any>,NO
29,gmp,/ureports/ibgmp/pcd/rpts/nofiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/pcd/rpts/nofiche,YES,<where><any><yesterday><any>,NO
30,gmp,/ureports/rptsgmp/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/rpts/fiche,YES,<where><any><yesterday><any>,NO
31,gmp,/ureports/rptsgmp/results,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/export/results,YES,<where><any><yesterday><any>,NO
32,gmp,/ureports/exportgmp/fmc,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpfmcftp@sftp1: prod/gmp,YES,<where>fm<yesterday>,NO
33,gmp,/ureports/exportgmp/misc,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/export/misc,YES,<where><any><yesterday><any>,NO
34,gmp,/ureports/exportgmp/yrend,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/export/yrend,YES,<where><any><yesterday><any>,NO
35,gmp,/ureports/ibgmp/gmp/rpts/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/gmp/rpts/fiche,YES,<where><any><yesterday><any>,NO
36,gmp,/ureports/ibgmp/gme/rpts/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/gme/rpts/fiche,YES,<where><any><yesterday><any>,NO
37,gmp,/ureports/ibgmp/gmu/rpts/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/gmu/rpts/fiche,YES,<where><any><yesterday><any>,NO
38,rjl,/ureports/exportrjl/extracts,/home/dslmain/rjl/scripts/copylsoftosftphigh.sh,rjlsftp@sftp1: prod/rjl/export/extracts,HIGH,<where>cabfa<yesterday> <where>cabins<yesterday> <where>cabtrd<yesterday>
<where>ecom<yesterday><any> <where>nilog<yesterday><any> <where>oldbil<yesterday><any> <where>bil<yesterday><any> <where>mstrcopy<yesterday><any> <where>bk<yesterday><any> <where>dierr<yesterday><
any> <where>di<yesterday><any> <where>dc<yesterday><any> <where>sr<yesterday><any> <where>clcd<yesterday><any> <where>spc<yesterday><any> <where>fx<yesterday><any> <where>tr<yesterday><any> <where>sm<y
esterday><any> <where>CIT<yesterday><any> <where>iausr<yesterday><any>,NO
39,rjl,/ureports/ibrjl/usa/export/extracts,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/export/extracts,YES,<where><any><yesterday><any>,NO
40,rjl,/ureports/exportrjl/extracts,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjltgfsftp@sftp1: prod/rjl,YES,<where>mcp<yesterday> <where>msp<yesterday> <where>mstr<yesterday> <where>mbk<yesterday>,NO
41,rjl,/uhome/dslmain/rjl/EOT,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/EOT,YES,<where>CONTROL_<yesterday>.txt <where>REP_<yesterday>.txt,NO
42,rjl,/ureports/exportrjl/results,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/export/results,YES,<where><any><yesterday><any>,NO
43,rjl,/ureports/rptsrjl/nofiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/nofiche,YES,<where><any><yesterday><any>,NO
44,rjl,/ureports/rptsrjl/confirm,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/confirm,YES,<where>c<yesterday><any>,NO
45,rjl,/ureports/rptsrjl/status,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/status,YES,<where>ss<yesterday><any>,NO
46,rjl,/ureports/rptsrjl/yrend,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/yrend,YES,<where><any><yesterday><any>,NO
47,rjl,/ureports/exportrjl/misc,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/export/misc,YES,<where><any><yesterday><any>,NO
48,rjl,/ureports/ibrjl/usa/rpts/fiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/rpts/fiche,YES,<where><any><yesterday><any>,NO
49,rjl,/ureports/ibrjl/usa/rpts/nofiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/rpts/nofiche,YES,<where><any><yesterday><any>,NO
50,rjl,/ureports/ibrjl/usa/export/misc,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/export/misc,YES,<where><any><yesterday><any>,NO
51,rjl,/ureports/rptsrjl/confirm,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjltelusftp@sftp1: prod/rjl,YES,<where>confirm.<yesterday>.xml <where>xml.confirm.<yesterday>.err,NO
52,rjl,/ureports/rptsrjl/fiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/fiche,YES,<where><any><yesterday><any>,NO
53,rjl,/ureports/exportrjl/yrend,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/export/yrend,YES,<where><any><yesterday><any>,NO
54,rjl,/ureports/fussrjl/daily,/home/dslmain/rjl/scripts/copylsoftosftpwithmove.sh,rjltelusftp@sftp1: prod/rjl,EXPORT,<where>usac<any>.<any> <where>rjlh<any>.ps <where>rjl<any>.pc.<any>,NO
55,rjl,/uhome/dslmain/rjl/EOT,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjltelusftp@sftp1: prod/rjl,YES,<where>con<yesterday>.flg <where>rep<any><yesterday>.flg <where>pos<yesterday>.flg,NO
56,rjl,/ureports/exportrjl/extracts,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsubservoftp@sftp1: prod/rjl,YES,<where>dc<yesterday> <where>sr<yesterday> <where>di<yesterday> <where>bk<yesterday> <wh
ere>sm<yesterday> <where>tr<yesterday> <where>cabfa<yesterday> <where>cabins<yesterday> <where>cabtrd<yesterday>,YES
65,asi,/ureports/exportasi/extracts,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/export/extracts,YES,<where>asi_kyc<yesterday><any> <where>auam<yesterday><any> <where>asiauaw<yes
terday><any> <where>bil<yesterday><any> <where>corpbil<yesterday><any> <where>bk<yesterday><any> <where>ecptmp<yesterday><any> <where>esmtmp<yesterday><any> <where>esrtmp<yesterday><any> <where>househo
ld<yesterday><any> <where>iausr<yesterday><any> <where>kyc<yesterday><any> <where>na<yesterday><any> <where>oldbil<yesterday><any> <where>clcd<yesterday><any> <where>dc<yesterday><any> <where>dc.flg<ye
sterday><any> <where>dc2<yesterday><any> <where>fx<yesterday><any> <where>spc<yesterday><any> <where>sr<yesterday><any> <where>tr<yesterday><any>,NO
66,asi,/uhome/dslmain/asi/EOT,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/EOT,YES,<where>CONTROL_<yesterday>.txt <where>REP_<yesterday>.txt,NO
67,asi,/ureports/rptsasi/nofiche,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/nofiche,YES,<where><any><yesterday><any>,YES
68,asi,/ureports/rptsasi/confirms,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/confirm,YES,<where>c<yesterday><any>,NO
69,asi,/ureports/rptsasi/status,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/status,YES,<where>ss<yesterday><any>,NO
70,asi,/ureports/rptsasi/yrend,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/yrend,YES,<where><any><yesterday><any>,NO
71,asi,/ureports/exportasi/misc,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/export/misc,YES,<where><any><yesterday><any>,NO
72,asi,/ureports/exportasi/yrend,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/export/yrend,YES,<where><any><yesterday><any>,NO
73,faunus,/home/dslmain/import/esg/asi/new/sent,/home/dslmain/faunus/scripts/copylsoftosftpwithmove.sh,atbsftp@sftp1: prod/asi/esg,NO,<where>as<any>,NO
File fuss_lsof_conf2.txt contains (after adding\deleting\altering):
34,gmp,/ureports/exportgmp/yrend,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/export/yrend,YES,<where><any><yesterday><any>,NO
35,gmp,/ureports/ibgmp/gmp/rpts/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/gmp/rpts/fiche,YES,<where><any><yesterday><any>,NO
36,gmp,/ureports/ibgmp/gme/rpts/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/gme/rpts/fiche,YES,<where><any><yesterday><any>,NO
37,gmp,/ureports/ibgmp/gmu/rpts/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/gmu/rpts/fiche,YES,<where><any><yesterday><any>,NO
38,rjl,/ureports/exportrjl/extracts,/home/dslmain/rjl/scripts/copylsoftosftphigh.sh,rjlsftp@sftp1: prod/rjl/export/extracts,HIGH,<where>cabfa<yesterday> <where>cabins<yesterday> <where>cabtrd<yesterday>
<where>ecom<yesterday><any> <where>nilog<yesterday><any> <where>oldbil<yesterday><any> <where>bil<yesterday><any> <where>mstrcopy<yesterday><any> <where>bk<yesterday><any> <where>dierr<yesterday><
any> <where>di<yesterday><any> <where>dc<yesterday><any> <where>sr<yesterday><any> <where>clcd<yesterday><any> <where>spc<yesterday><any> <where>fx<yesterday><any> <where>tr<yesterday><any> <where>sm<y
esterday><any> <where>CIT<yesterday><any> <where>iausr<yesterday><any>,NO
39,rjl,/ureports/ibrjl/usa/export/extracts,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/export/extracts,YES,<where><any><yesterday><any>,NO
40,rjl,/ureports/exportrjl/extracts,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjltgfsftp@sftp1: prod/rjl,YES,<where>mcp<yesterday> <where>msp<yesterday> <where>mstr<yesterday> <where>mbk<yesterday>,NO
41,rjl,/uhome/dslmain/rjl/EOT,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/EOT,YES,<where>CONTROL_<yesterday>.txt <where>REP_<yesterday>.txt,NO
42,rjl,/ureports/exportrjl/results,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/export/results,YES,<where><any><yesterday><any>,NO
43,rjl,/ureports/rptsrjl/nofiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/nofiche,YES,<where><any><yesterday><any>,NO
44,rjl,/ureports/rptsrjl/confirm,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/confirm,YES,<where>c<yesterday><any>,NO
45,rjl,/ureports/rptsrjl/status,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/status,YES,<where>ss<yesterday><any>,NO
46,rjl,/ureports/rptsrjl/yrend,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/yrend,YES,<where><any><yesterday><any>,NO
47,fid,/ureports/exportrjl/misc,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/export/misc,YES,<where>gjv<any><yesterday><any>,NO
48,fid,/ureports/ibrjl/usa/rpts/fiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/rpts/fiche,YES,<where><any><yesterday><any>,NO
49,rjl,/ureports/ibrjl/usa/rpts/nofiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/rpts/nofiche,YES,<where><any><yesterday><any>,NO
50,rjl,/ureports/ibrjl/usa/export/misc,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/export/misc,YES,<where><any><yesterday><any>,NO
51,rjl,/ureports/rptsrjl/confirm,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjltelusftp@sftp1: prod/rjl,YES,<where>confirm.<yesterday>.xml <where>xml.confirm.<yesterday>.err,NO
52,rjl,/ureports/rptsrjl/fiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/fiche,YES,<where><any><yesterday><any>,NO
53,rjl,/ureports/exportrjl/yrend,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/export/yrend,YES,<where><any><yesterday><any>,NO
54,rjl,/ureports/fussrjl/daily,/home/dslmain/rjl/scripts/copylsoftosftpwithmove.sh,rjltelusftp@sftp1: prod/rjl,EXPORT,<where>usac<any>.<any> <where>rjlh<any>.ps <where>rjl<any>.pc.<any>,NO
55,rjl,/uhome/dslmain/rjl/EOT,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjltelusftp@sftp1: prod/rjl,YES,<where>con<yesterday>.flg <where>rep<any><yesterday>.flg <where>pos<yesterday>.flg,NO
56,rjl,/ureports/exportrjl/extracts,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsubservoftp@sftp1: prod/rjl,YES,<where>dc<yesterday> <where>sr<yesterday> <where>di<yesterday> <where>bk<yesterday> <wh
ere>sm<yesterday> <where>tr<yesterday> <where>cabfa<yesterday> <where>cabins<yesterday> <where>cabtrd<yesterday>,YES
65,asi,/ureports/exportasi/extracts,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/export/extracts,YES,<where>asi_kyc<yesterday><any> <where>auam<yesterday><any> <where>asiauaw<yes
terday><any> <where>bil<yesterday><any> <where>corpbil<yesterday><any> <where>bk<yesterday><any> <where>ecptmp<yesterday><any> <where>esmtmp<yesterday><any> <where>esrtmp<yesterday><any> <where>househo
ld<yesterday><any> <where>iausr<yesterday><any> <where>kyc<yesterday><any> <where>na<yesterday><any> <where>oldbil<yesterday><any> <where>clcd<yesterday><any> <where>dc<yesterday><any> <where>dc.flg<ye
sterday><any> <where>dc2<yesterday><any> <where>fx<yesterday><any> <where>spc<yesterday><any> <where>sr<yesterday><any> <where>tr<yesterday><any>,NO
66,asi,/uhome/dslmain/asi/EOT,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/EOT,YES,<where>CONTROL_<yesterday>.txt <where>REP_<yesterday>.txt,NO
67,asi,/ureports/rptsasi/nofiche,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/nofiche,YES,<where><any><yesterday><any>,YES
68,asi,/ureports/rptsasi/confirms,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/confirm,YES,<where>c<yesterday><any>,NO
69,gmp,/ureports/rptsasi/status,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/status,YES,<where>ss<yesterday><any>,NO
70,asi,/ureports/rptsasi/yrend,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/yrend,YES,<where><any><yesterday><any>,NO
71,asi,/ureports/exportasi/misc,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/export/misc,YES,<where><any><yesterday><any>,NO
72,asi,/ureports/exportasi/yrend,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/export/yrend,YES,<where><any><yesterday><any>,NO
73,faunus,/home/dslmain/import/esg/asi/new/sent,/home/dslmain/faunus/scripts/copylsoftosftpwithmove.sh,atbsftp@sftp1: prod/asi/esg,NO,<where>as<any>,NO
74,gjv,/ureports/exportasi/yrend,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/export/yrend,YES,<where><any><yesterday><any>,NO
75,trout,/ureports/rptsrjl/fiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/fiche,YES,<where><any><yesterday><any>,NO
So via MySQL I made the following changes to these rules:
altered 47, 48
added 74, 75
deleted 28 - 33
This is reflected in the output of the diff command which I save too diff_fuss_file.txt
[dslgvol@rua tmp]$ more diff_fuss_file.txt
1,6d0
< 28,gmp,/ureports/ibgmp/pcd/rpts/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/pcd/rpts/fiche,YES,<where><any><yesterday><any>,NO
< 29,gmp,/ureports/ibgmp/pcd/rpts/nofiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/pcd/rpts/nofiche,YES,<where><any><yesterday><any>,NO
< 30,gmp,/ureports/rptsgmp/fiche,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/rpts/fiche,YES,<where><any><yesterday><any>,NO
< 31,gmp,/ureports/rptsgmp/results,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/export/results,YES,<where><any><yesterday><any>,NO
< 32,gmp,/ureports/exportgmp/fmc,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpfmcftp@sftp1: prod/gmp,YES,<where>fm<yesterday>,NO
< 33,gmp,/ureports/exportgmp/misc,/home/dslmain/gmp/scripts/copylsoftosftp.sh,gmpsftp@sftp1: prod/gmp/export/misc,YES,<where><any><yesterday><any>,NO
32,33c26,27
< 47,rjl,/ureports/exportrjl/misc,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/export/misc,YES,<where><any><yesterday><any>,NO
< 48,rjl,/ureports/ibrjl/usa/rpts/fiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/rpts/fiche,YES,<where><any><yesterday><any>,NO
---
> 47,fid,/ureports/exportrjl/misc,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/export/misc,YES,<where>gjv<any><yesterday><any>,NO
> 48,fid,/ureports/ibrjl/usa/rpts/fiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/usa/rpts/fiche,YES,<where><any><yesterday><any>,NO
63c57
< 69,asi,/ureports/rptsasi/status,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/status,YES,<where>ss<yesterday><any>,NO
---
> 69,gmp,/ureports/rptsasi/status,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/rpts/status,YES,<where>ss<yesterday><any>,NO
67a62,63
> 74,gjv,/ureports/exportasi/yrend,/home/dslmain/asi/scripts/copylsoftosftp.sh,atbsftp@sftp1: prod/asi/export/yrend,YES,<where><any><yesterday><any>,NO
> 75,trout,/ureports/rptsrjl/fiche,/home/dslmain/rjl/scripts/copylsoftosftp.sh,rjlsftp@sftp1: prod/rjl/rpts/fiche,YES,<where><any><yesterday><any>,NO
So now here's where I am totally lost...I need to produce a detail & summary report (in a file) that looks somewhat like the file I have attached to this thread.
So you can see that for altered records I need to show the new one and then in the SPECIFICS column show what changed.
Hope this is all clear; if not please do ask questions.
Thanks in advance of any\all help.
Regards
Giuliano
Could you please Upload the 2 csv dump files of the lsof_conf table before & after someone modified it, so people will then have a real example and may be able to provide you a more accurate answer.
Please ignore this request...it is too undoable the way I have explained it...I will regroup and provide a different solution that I would like some assiatnce with...thank you all for looking.
I am running diff between two directories dir1 and dir2.
diff --exclude --recursive --brief -b dir1 dir2
The output of the above command is
Files dir1/java/abc/bcd/abc9991.java and dir2/java/abc/bcd/abc9991.java differ
Files dir1/java/abc/bcd/abc9933.java and... (11 Replies)
How to get diff to not print the chevrons and the dashes? In this case the differences are all single line differences.
Also the first few lines don't matter. How to get the output to always exclude the first few lines? Thanks! (1 Reply)
Hello all;
I'll try an explain my dilemma as best I can. But first some background:
1- I am suppose to compare a database to itself before and after changes; basically generate audit trail report.
2- This database contains "RULES" (the id field) that we use for transmitting files.
3 - The... (0 Replies)
I have two files to compare, but diff output doesn't give me decent output I want.
The portion of the two files are shown below.
file 1)
Authorize <1>
Transaction Database Slave 3 <1>
CPM HTTP Proxy Server <1>
SSP (TDB Server) <1>
CPM Application Authorization <7>
CPM Script... (5 Replies)
Hey guys,
I have this file generated by me... i want to create some HTML output from it.
The problem is that i am really confused about how do I go about reading the file.
The file is in the following format:
TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Hello is there a way to limit the number of lines output by the DIFF command?
I tried -C 200 ect and -c but it continues to print out the whole huge file.
Reason needed is i'm trying to do alot of DIFFs on a long list of files and would like to only get back an indicator which files are... (2 Replies)
hi,
i have a script which pipes the output of a diff -rq command into a separate file/ it would read something like this:
Files mod1/lala/xml/test1.txt and mod2/lala/xml/test1.txt differ
Only in mod2/lala/xml: test2.txt
What i need to do is to parse this file so i end up with just a... (5 Replies)
I have two CSV files and I would like to create a third CSV file containing the differences between the two.
I understand the diff command can be used to list differences between two files. My problem is that when I pipe the output into a third CSV file, the line numbers and other formatting... (3 Replies)
Hello,
I want to compare two files. All records in file 2 that are not in file 1 should be output to file 3.
For example:
file 1
123
1234
123456
file 2
123
2345
23456
file 3 should have
2345
23456
I have looked at diff, bdiff, cmp, comm, diff3 without any luck! (2 Replies)