call an URL - get the tsv file, and read it?

[mtm81]

Hi All,
I have an URL which when I use a GET request and send several variables, will generate a TSV file.

This URL is on another server by the way.

So my script needs to :
1) - Send a get request to this other server URL
2) - Grab the resutling file (it's labelled as .cgi file, but is in fact a tab delimited .tsv file

3) - Loop through each line of the file and do some work on it.


If I can read the file and the individual lines I can do the inner loop work myself, it's more the grabbing of the file.

I've done stuff in the past using a get request to grab some XML of a second server, but this is an actual file...

Any ideas?

[russell]

use MSXML2.XMLHTTP just as though you were retrieving xml. can parse the response stream and write to file