reading multiple files but for each file read add a date .simialrly when reading next file again add date

[dennis_oz]

reading multiple files but for each file read add a date .simialrly when reading next file again add date

eg:

file place in a directory : XX\zz_20150515,

                                    XX\zz_20150516

                                    XX\zz_20150517

read each file and for each file read. Add date in all the records

acct_id , unique, date

------------ ----------- -------

1212      asdasd 20150515

1233      asdasd 20150515

3444     asdadad 20150516

1313     dsfsdfssf 20150516

4323     sszzsscz 20150516

6568    asddasdw  20150517

132     sfdfsfsdfsd  20150517

please help

[RW9]

Have a look at data _null_'s post here:

Once you have the filename in a variable then you can scan(filename,2,"_") to get the date.