Hello all;
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
