CSV File Scripting Requirement

A script program is required to insert a first data row to financial instrument data. The output of a charting program produces many .csv files in the following format: 03/01/2006 3.32 3.32 3.24 3.25 71600000 04/01/2006 3.28 3.29 3.25 3.28 45300000 ... Each file typically contains hundreds of data rows and there may be over a hundred files to be processed. Sample data for development/testing will be provided. The script should add the following header row to each file: Date O H L C Volume So that the resulting file looks like: Date O H L C Volume 03/01/2006 3.32 3.32 3.24 3.25 71600000 04/01/2006 3.28 3.29 3.25 3.28 45300000 ... Usage 1. It must be possible to run the script on a single file from the command line, e.g. <script_name> <file_name> 2. It must be possible to process a set of files in a folder, e.g. <script_name> <path_name><file_name> (including a wildcard, e.g. *.csv) 3. Sometimes, the Volume column is not present in the source data. In this case only Date, O, H, L, and C column headings should be written 4. Sometimes, only some of the files are new, so if a header row already exists, the source file should remain untouched Notes 1. The script will be run on a Vista machine, 2. It is presumed the script will be developed in WSH (negotiable, but don’t want complex installation pre-requisites)