filepattern read, need to split on date , and process loop
Moderators: chulett, rschirm, roy
filepattern read, need to split on date , and process loop
I have six files , i am reading in file pattern manner, files will ahve this names BLG_LB_010213.txt,BLG__SA_010213.txt,BLG__AD_010213.txt, but for some reason if my etl process doest run, there will be 6 files now , 3 with previous day, and 3 new from current date,BLG_LB_010313.txt,BLG__SA_010313.txt,BLG__AD_010313.txt , how do i split them based on date and seklect only the 3 files with same date and run and loop again?
sameer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: