|
PureBytes Links
Trading Reference Links
|
Eugene,
I think you will need a fairly simple VBA Excel
routine to pick up the date from the CSV file and
insert it as a new column in the file. Apart from
that, your only way out is to manually fill in the
date in the first row (within Excel) and pull it down
to the end of the file.
Cheers,
Lal
--- Eugene <eugenecpinto@xxxxxxxxxxx> wrote:
> I have multiple csv files with 15 columns of data
>
> It is missing a date column which is contained in
> the file name
>
> Is there anyway we can add a column to the csv file
> with the date that
> is contained in the file name in dmy format
>
> TIA
>
>
___________________________________________________________
New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes.
http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.14/637 - Release Date: 1/18/2007 1:03 PM
|