I am looking for a vbscript procedure to cover the following requirements:
-Compile multiple csv files located in C:\Input folder
-Generate a single Compiled file into C:\Input folder with a name to report in the script and date stamp. Example YYYYMMDD_Reported_Name.csv
-Move the various compiled files into C:\Archive.
First row (header generated in Compiled file should be taken into account by reference reported file in the script
Variables should be the following:
-strInput= Folder in which are located files to compiled and compiled files.
-strArchive=Folder which should receive compiled files
nce compiled file name
-strHeaderFilename= Reference file which should be read in order to generate headers
-Every file to compiled has the same number of columns.
-Compilation process start as of line 2 in order to avoid having headers in compiled file. If possible have a initHeader variable if we want to reuse script;
-Previous verification actions before launching compile process are the following
If reported folders don’t exist, the procedure should create the folders.
-Generate a log file into C:\Input folder
-Report if folders have been created or already exist.
I attached files to combine for testing
If you have questions or need clarifications please contact me.
Thank you very much for your help.