pulling plain text into something I can work with

The site, which is almost finished, is at
http://site234.webhost4life.com/crgmdal7/

If you click most of the links in the gold nav bar, they will take you to
various places within the site. But if you select the one called "Loads", it
takes you to http://www.crgm06.com/aval.txt, which I have opened into a new
window.  As you can see, it's a plain text file, and it is on a different
domain, which I have no control over. The data in there changes all the
time.

Is there a way I can import this into one of the pages I have control over,
and parse it out and display it the way I want?  I've never worked with
importing plain text that's generated on the fly before.

Using Classic ASP, have SQL Server or Access available, but not using it for
anything else on the side.

There are probably a number of ways that you can this.  The first one that
comes to my mind, is this.

That text file is of the fixed-length variety.  If that length always stays
the same, which I'm going to imagine it does, you could try

1.  http://www.aspfaq.com/show.asp?id=2173 to grab the text from the site
2.  Save the .ResponseText to a file using the File Scripting Object
3.  Use ADO to query out a recordset of the data.

Check out this page about ADO and text files.
http://msdn.microsoft.com/library/d...ing03092004.asp

Really, this .txt page you point to is an excellent candidate for RSS, but
well, that's probably out of the scope of what you can control if that's not
your site!  :]

Ray at work



"middletree" <middletree@htomail.com> wrote in message
news:OLbS%23FipEHA.3728@TK2MSFTNGP09.phx.gbl...
> The site, which is almost finished, is at
> http://site234.webhost4life.com/crgmdal7/
>
> If you click most of the links in the gold nav bar, they will take you to
> various places within the site. But if you select the one called "Loads",
> it
> takes you to http://www.crgm06.com/aval.txt, which I have opened into a
> new
> window.  As you can see, it's a plain text file, and it is on a different
> domain, which I have no control over. The data in there changes all the
> time.
>
> Is there a way I can import this into one of the pages I have control
> over,
> and parse it out and display it the way I want?  I've never worked with
> importing plain text that's generated on the fly before.
>
> Using Classic ASP, have SQL Server or Access available, but not using it
> for
> anything else on the side.
>
>

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message

> Really, this .txt page you point to is an excellent candidate for RSS, but
> well, that's probably out of the scope of what you can control if that's
not
> your site!  :]
>
> Ray at work


I'll try your suggestions. Hope it's clear that the blue site is mine. But
that txt one is not.

And what's RSS?

"middletree" <middletree@htomail.com> wrote in message
news:e7dj%23TjpEHA.3668@TK2MSFTNGP15.phx.gbl...

>
>
> I'll try your suggestions. Hope it's clear that the blue site is mine. But
> that txt one is not.

Yes, that was clear!  :]


> And what's RSS?

That's when a page returns data in XML format and you can, programatically,
pull in that "data feed," and do whatever you want with it, such as applying
an XSLT style sheet to it and displaying it, or just using the XML as a data
source for some other purpose.

Ray at work

You could download file when a page is selected and using FSO read one line
at a time and place it in a table.
It looks like it is tab delimited so you could slice and dice into columns
during table insertion.
Or, what I would be doing is using a script to place the details in an xml
file once a day , then  reading xml file for client display.
Don



"middletree" <middletree@htomail.com> wrote in message
news:OLbS%23FipEHA.3728@TK2MSFTNGP09.phx.gbl...
> The site, which is almost finished, is at
> http://site234.webhost4life.com/crgmdal7/
>
> If you click most of the links in the gold nav bar, they will take you to
> various places within the site. But if you select the one called "Loads",
> it
> takes you to http://www.crgm06.com/aval.txt, which I have opened into a
> new
> window.  As you can see, it's a plain text file, and it is on a different
> domain, which I have no control over. The data in there changes all the
> time.
>
> Is there a way I can import this into one of the pages I have control
> over,
> and parse it out and display it the way I want?  I've never worked with
> importing plain text that's generated on the fly before.
>
> Using Classic ASP, have SQL Server or Access available, but not using it
> for
> anything else on the side.
>
>

Hi,

>And what's RSS?

RSS is the standard for providing content headlines and summaries. It starte
d
out for simply news publications but its use has signficantly expanded.
http://www.rss-specifications.com/everything-rss.htm

HTH

Ria