I have a problem that I was wondering how to resolve. My application is processing a number of CSV files every day that are named as ABC_NNN.CSV where the ABC part signifies the client and the NNN is a Julian number where 000 is 1st January and 365 is 31st December.
The above naming convention lacks a YEAR number which is a must so this must be added either by
a) renaming each of the CSV files that I receive to include the year (e.g. ABC_2014_267.CSV for yesterdays data file for client ABC) OR
b) by creating QVD files for each CSV that are named as per their source plus the year (e.g. ABC_2014_267.QVD for yesterdays data file for client ABC).
Each approach will make use of the:
FOR EACH file IN filelist('*.csv')
.....
NEXT file
syntax but I am stuck with how to handle the renaming (if that is the way forward) or the creation of the QVDs in an iterative approach.
