D
Diana
I have about 200 csv files in a directory.
For example, C:\myfolder\amd.csx, C:\myfoler\bux.csx, C:\myfolder\abc.csx ....
The csv files have the following format:
AMD, 12-Apr-00, 1.4, 1.3, 1.22, 1.5, 627044
AMD, 13-Apr-00, 1.33, 1.23, 1.45, 1.33, 667788
AMD..etc..
First value is the same as the file name, second value is a date
(dd-mmm-yy), the rest are numbers.
Now I have a .txt file. The format is:
AMD, 091012, 1.88, 1.67, 1.45, 1.23, 345678
BUX, 091012, 11, 11.35, 10.9, 11.2, 627044
ABC, 091012, 10.86, 10.89, 10.75, 10.75, 476009
etc.
The first value is the name of the csv file. The second value is the date
(yymmdd). The rest are numbers.
I get one such txt file per work day.
I want to open the text file, then open each corresponding csv (if found).
The first value of each line tells me which csv file to open. Now update the
csv file with the info in the .txt file. ie. it appends the relevant line
from the txt file to the csv file.
Thanks in advance!
For example, C:\myfolder\amd.csx, C:\myfoler\bux.csx, C:\myfolder\abc.csx ....
The csv files have the following format:
AMD, 12-Apr-00, 1.4, 1.3, 1.22, 1.5, 627044
AMD, 13-Apr-00, 1.33, 1.23, 1.45, 1.33, 667788
AMD..etc..
First value is the same as the file name, second value is a date
(dd-mmm-yy), the rest are numbers.
Now I have a .txt file. The format is:
AMD, 091012, 1.88, 1.67, 1.45, 1.23, 345678
BUX, 091012, 11, 11.35, 10.9, 11.2, 627044
ABC, 091012, 10.86, 10.89, 10.75, 10.75, 476009
etc.
The first value is the name of the csv file. The second value is the date
(yymmdd). The rest are numbers.
I get one such txt file per work day.
I want to open the text file, then open each corresponding csv (if found).
The first value of each line tells me which csv file to open. Now update the
csv file with the info in the .txt file. ie. it appends the relevant line
from the txt file to the csv file.
Thanks in advance!