Hi,
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.
Any ideas would be very welcome indeed.
Thanks in advance
Alexis