Posted by Ben C on 10/31/06 11:26

On 2006-10-31, howcanimissu@hotmail.com <howcanimissu@hotmail.com> wrote:
> Thanks,
>
> I will check out these tools, if I can save the file I can trigger a
> conversion in excel I think,

It's probably easiest to turn the "pipe-delimited" thing into csv (maybe
as simple as replace | with ,) and let Excel convert the csv to xls.

[snip]
>> > I am wondering what the simpliest tool or best way is to go to website
>> > using a program or tool and either:
>> > a) saving the file at the URL ( In this case a ***.txt file is the url)
>> > so it would be something like http:// www.testsite.com/testfile.txt .
>> > This file is a simple pipe delimited text file with some rudimentary
>> > data on it. I would like to automate this process so that whatever tool
>> > I use goes to the site once every minute to get an update and saves the
>> > file to my ftp.
>>
>> There are lots of ways. To get the page, wget or curl are suitable
>> programs, Python's httplib will also do it.

[Back to original message]