<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]
