[Zxarr]

Greetings,

I am trying to write a script that will take a list of items from a file and append them into a CSV file...

This script will run each day, taking each item from the 'item.txt' file and appending it to the end of the last line of a csv file that is already there:

The itemlist.csv file looks like this before the items are added:

date,time,foo,bar

and must look like this afterwards:

date,time,foo,bar,item1,item2,item3,item4

The number of items in the item.txt file can change each day.

Now, if this were bash shell scripting, no problems, but I have to do this on a Windows Server...

Thanks.

[johnhe]

You could create a text file containing a single comma and then use this batch file to get the result you are looking for.

@echo off
copy itemlist.csv + comma.txt + item.txt tmp.csv
del itemlist.csv
ren tmp.csv itemlist.csv

John Hensley
www.resqware.com