Home > Archive > ASP > September 2004 > pulling plain text into something I can work with
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
pulling plain text into something I can work with
|
|
| middletree 2004-09-29, 8:55 am |
| 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] 2004-09-29, 3:55 pm |
| 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.
>
>
| |
| middletree 2004-09-29, 3:55 pm |
|
"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?
| |
| Ray Costanzo [MVP] 2004-09-29, 3:55 pm |
|
"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
| |
| Donald Grover 2004-09-29, 9:27 pm |
| 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.
>
>
| |
|
|
|
|
|