Matthew, you are always saving my bung!
Thanks, i really do appriciate it :)
dave

---------- Original Message ----------------------------------
From: Matthew Walker <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Fri, 23 Jul 2004 14:40:02 +1200

>Read the data into a variable "data" with cffile. Then do this:
>
>
>
><cfset line = listLast(data, chr(13))>
>
><cfset splitLine = listToArray(line, chr(8))>
>
>
>
>splitLine[3] is the date/time
>
>splitLine[4] and splitLine[5] are the values you need.
>
>
>
>Once that's working, you may want to write your code to read the last 96
>(i.e. 24 hours) of lines every 15 min instead of just the last line. Then
>you'd need to check each line wasn't already in the database. This would
>protect you against losing data during server hiccups.
>
>
>
>
>
>  _____  
>
>From: dave [mailto:[EMAIL PROTECTED]
>Sent: Friday, 23 July 2004 2:16 p.m.
>To: CF-Talk
>Subject: i need help stripping :)
>
>
>
>i need to get a bunch of stream flows from the state site unfortunatly,
>their xml output doesnt work
>sooooooooooooooooooooo
>heres the scoop what this is are stream flows for a fishing site so i will
>need to enter each url (on each stream) to get info, then parse the page
>which will be a tab del
>like
>http://waterdata.usgs.gov/co/nwis/uv?dd_cd=01&dd_cd=18&format=rdb&period=1&s
>ite_no=09085000
>
>then i need to grab basically the info on the last line
>like
>09085000 2004-07-22 16:45 820 65.7
>
>seperate the info and dump into db every 15 mintes
>i have a few idea what i wanna do but id sure like some input as to the best
>way to do this
>
>thanks
>
>  _____  
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to