I would probably do a couple of things to simplify this before I tried to grab the numbers. First, I'd take all the content and use a RegEx to remove all the tags. What you'd be left with is
Visitor Sessions Visitor Sessions 176,308 Average Per Day 5,687 With some variabtion in whitespace -- all this is easy to parse. Basically, you grab the first set of numbers and commas for the Visitor Sessions, and the second set of digits and commas for the Average Per Day. If you need a more detailed solution than this, check the CF-RegEx archives (I believe we've covered tag stripping and pulling out numbers over the last month or so) at: http://www.houseoffusion.com/cf_lists/index.cfm?method=threads&forumid=21 Or, if you don't find what you need (or it turns out I just imagined it) post there and I'm sure you'll get all the help you need. --Ben Doom Programmer & General Lackey Moonbow Software : -----Original Message----- : From: [EMAIL PROTECTED] [mailto:hecgam@;attbi.com] : Sent: Tuesday, October 22, 2002 4:02 PM : To: CF-Talk : Subject: Reg Ex help : : : Hello - i'm new to the forum. I am just learning : regular expressions and need some help! : : i am using cffile to read a file and output a number to : another page using refindnocase to parse the data. : : here's the data i want to parse: : : <TR BGCOLOR="FFFFFF"> : <TD rowspan=6 valign=top ALIGN ="LEFT" width='30%'> : <FONT SIZE=1 FACE="ms sans : serif,arial,helvetica,verdana,lucida,utopia" : COLOR="000000"><B>Visitor Sessions</B></FONT></TD> : <TD ALIGN ="LEFT" > : <FONT SIZE=1 FACE="ms sans : serif,arial,helvetica,verdana,lucida,utopia" : COLOR="000000">Visitor Sessions</FONT></TD> : <TD ALIGN ="RIGHT" > : <FONT SIZE=1 FACE="ms sans : serif,arial,helvetica,verdana,lucida,utopia" : COLOR="000000">176,308</FONT></TD> : </TR> : <TR BGCOLOR="FFFFFF"> : <TD ALIGN ="LEFT" > : <FONT SIZE=1 FACE="ms sans : serif,arial,helvetica,verdana,lucida,utopia" : COLOR="000000">Average Per Day</FONT></TD> : <TD ALIGN ="RIGHT" > : <FONT SIZE=1 FACE="ms sans : serif,arial,helvetica,verdana,lucida,utopia" : COLOR="000000">5,687</FONT></TD> : </TR> : : This code where the number is located is repeated for : each different subject. I need help to get the Visitor : Session number using a regular expression. And then get : the Average Session length (but i can do that by just : changing the code from Visitor session). : : Probably need to start from the >visitor : : Thanks! : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
