In Progress

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 [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] 71600000

04/01/2006 [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] 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 [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] 71600000

04/01/2006 [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] 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)

Skills: Perl, Script Install

See more: data set testing, insert date, file folder, CSV, csv data, file source, rows insert, sample perl, charting program, column already exists, perl sample, csv column format, testing requirement, requirement development, development notes, format file, financial case, source file, line csv, command line written, data usage, complex format, testing perl, csv data source, csv data process

About the Employer:
( 5 reviews ) Coventry, United Kingdom

Project ID: #221472

Awarded to:

vnb400

kindly refer PMB, Thanks

$30 USD in 1 day
(3 Reviews)
1.6

6 freelancers are bidding on average $51 for this job

gangabass

I can do this job for you. See PM for details.

$30 USD in 1 day
(158 Reviews)
6.0
iDivya

Hi, Please read my message...

$50 USD in 0 days
(22 Reviews)
5.0
pentium10

Professional work from professionals!

$50 USD in 1 day
(48 Reviews)
5.0
karmu

lets do it, please check pm , have send detail

$100 USD in 2 days
(14 Reviews)
4.2
Ellemer

Please check PM box, thanks

$48 USD in 1 day
(4 Reviews)
3.1