473,788 Members | 2,825 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.
Jul 19 '05 #1
5 1449
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/de...ng03092004.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 " <mi********@hto mail.com> wrote in message
news:OL******** ********@TK2MSF TNGP09.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.

Jul 19 '05 #2

"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?
Jul 19 '05 #3

"middletree " <mi********@hto mail.com> wrote in message
news:e7******** ********@TK2MSF TNGP15.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
Jul 19 '05 #4
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 " <mi********@hto mail.com> wrote in message
news:OL******** ********@TK2MSF TNGP09.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.

Jul 19 '05 #5
Ria
Hi,
And what's RSS?


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

HTH

Ria

Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
3369
by: LRW | last post by:
I have an automated process which uploads a comma separated spreadsheet (csv) and inserts it into a database: $sql = "LOAD DATA INFILE '".$uploadfile."' INTO TABLE `tbl_tracking` FIELDS TERMINATED BY ','". "OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'". "( `tr_trackno` , `tr_ordernum` , `tr_shipname` , `tr_shipaddr` , `tr_citystate` , `tr_zip` , `tr_weight` , `tr_method` , `tr_shipdate` )";
10
2851
by: Steve | last post by:
Hi all i am just starting to get back into VB and i need a little help. I am writing a program that asks a user to type in a set of numbers/letters (in this case shipping containers). Once the data is entered i have my 4 letters and i want to be able to call up data relating to the 4 letters. Basically i want it to show who the container belongs to and any other data i wish to put in there relating to the container.
2
11480
by: Russell Klopfer | last post by:
Hello. I would like to know how I can parse a plain-text file. All I want to do is be able to sequentially extract each word from a document. Similar to the StringTokenizer in Java. Is there a module for this? or an easy way to do it with regular expressions? Thanks!
10
4198
by: J. Alan Rueckgauer | last post by:
Hello. I'm looking for a simple way to do the following: We have a database that serves-up content to a website. Some of those items are events, some are news articles. They're stored in the DB as formatted HTML so ASP just drops them right into a page shell. Now, we want to send out a newsletter email containing some of those items. No problem sending as HTML. However, some of the members want just plain text. Is there some magic...
2
1801
by: Mike Bridge | last post by:
Is there any way to get Internet explorer to treat a text/plain .net page as plain text using asp.net? It seems like IE doesn't trust text/plain as a mime type, and so it (ironically) displays it as text/html. (This works fine in Mozilla, though.) I thought maybe IE would use the file extension as a guide, but it doesn't seem to work. I tried mapping the .txt extension in IIS so it is parsed by the .net framework, then setting up an...
3
2767
by: Nate Hekman | last post by:
I have an aspx page that generates a file on the fly for a person to download. It sends these http headers: Content-Type: text/plain Content-Disposition: attachment; filename="myfile.lic" The file being downloaded is a license file and MUST be stored with that ..lic extension. If I access this aspx page with IE, it prompts me if I want to open or save
5
2763
by: akelly_image | last post by:
Okay, if anyone could toss me some idea's here, please bare with my noobish questions, I just picked up VB2005 Pro about a week ago. ( no prior VB at all ) Here's my issue.. I'm pulling information out of a text file and need to pull specific words out of a string. For example, the text file looks sorta like this:
7
2277
by: danielbaars | last post by:
Hello, I'm almost a complete newbie to using PHP and I was hoping one of you guys can point me in the right direction. I'm working on a site for a brand of handmade fruit juice and it only needs one bit of dynamic content: the info on what fruit is in the juice and where it is coming from (vendor, country etc.) today and tomorrow (the content of the juice is different everyday). So I thought it would be easiest to put that information...
12
2373
by: Alexnb | last post by:
This is similar to my last post, but a little different. Here is what I would like to do. Lets say I have a text file. The contents look like this, only there is A LOT of the same thing. () A registry mark given by underwriters (as at Lloyd's) to ships in first-class condition. Inferior grades are indicated by A 2 and A 3. () The first three letters of the alphabet, used for the whole alphabet. () In church or chapel style; -- said of...
0
9656
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9498
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10175
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9969
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7518
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6750
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5399
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5536
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4070
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.