It's all tabular like that? If so you should be able to strip the header and footer and open it in excel and then save it comma delimited.
-----Original Message----- From: Dana Tierney [mailto:[EMAIL PROTECTED] Sent: Sunday, April 29, 2007 5:22 PM To: CF-Community Subject: Re: need a suggestion OK here is a snippet. The following comes after a big chunk of Javascript that talks about the menu and what tab I am on. I have changed the identifying information in the snippet, but left it in a similar format. For example, the student number is always an A followed by eight numbers, but there is no student named Mickey Mouse whose number is A00000000. The format would always be the same. I need the term and crn number from the second row of the first table. These identify the class. >From the next table I need the displayed text from the links in the first and second columns in the second and subsequent rows. These each identify a student. ---- <TABLE CLASS="datadisplaytable" summary="This table displays enrollment and waitlist counts."><CAPTION class="captiontext">Enrollment Counts</CAPTION> <TR> <TH CLASS="ddheader" scope="col" > </TH> <TH CLASS="ddheader" scope="col" >Maximum</TH> <TH CLASS="ddheader" scope="col" >Actual</TH> <TH CLASS="ddheader" scope="col" >Remaining</TH> </TR> <TR> <TH CLASS="ddlabel" scope="row" ><A HREF="/prod/bwlkfcwl.P_FacClaListSum?term=100630&crn=40110">Enrollment:< /A></TH> <TD CLASS="dddefault">30</TD> <TD CLASS="dddefault">22</TD> <TD CLASS="dddefault">8</TD> </TR> <TR> <TH CLASS="ddlabel" scope="row" >Cross List: </TH> <TD CLASS="dddefault">0</TD> <TD CLASS="dddefault">0</TD> <TD CLASS="dddefault">0</TD> </TR> </TABLE> <BR> <TABLE CLASS="datadisplaytable" summary="This table displays a list of students registered for the course; summary information about each student is provided." WIDTH="100%"><CAPTION class="captiontext">Summary Class List</CAPTION> <TR> <TH CLASS="ddheader" scope="col" >Record<BR>Number</TH> <TH CLASS="ddheader" scope="col" >Student Name</TH> <TH CLASS="ddheader" scope="col" ><ACRONYM title = "Identification Number">ID</ACRONYM></TH> <TH CLASS="ddheader" scope="col" ><ABBR title = "Registration Status">Reg Status</ABBR></TH> <TH CLASS="ddheader" scope="col" >Level</TH> <TH CLASS="ddheader" scope="col" >Credits</TH> <TH CLASS="ddheader" scope="col" >Midterm</TH> <TH CLASS="ddheader" scope="col" >Final</TH> <TH CLASS="ddheader" scope="col" >Grade Detail</TH> <TD CLASS="dddead"> </TD> </TR> <TR> <TD CLASS="dddefault">1</TD> <TD CLASS="dddefault"><SPAN class=fieldmediumtext><A HREF="/prod/bwlkosad.P_FacSelectAtypView?stupidm=00000&term=100630" onMouseOver="window.status='Student Information'; return true" onFocus="window.status='Student Information'; return true" onMouseOut="window.status=''; return true"onBlur="window.status=''; return true">Mouse, Mickey<A> </SPAN></TD> <TD CLASS="dddefault"><SPAN class=fieldmediumtext>A00000000</SPAN></TD> <TD CLASS="dddefault"><SPAN class=fieldmediumtext>**Web Registered**</SPAN></TD> <TD CLASS="dddefault"><SPAN class=fieldmediumtext>Undergraduate</SPAN></TD> <TD CLASS="dddefault"><SPAN class=fieldmediumtext> 3.000</SPAN></TD> <TD CLASS="dddefault"><SPAN class=fieldmediumtext><A HREF="/prod/bwlkfmgd.P_FacMidGrd?term=100630&crn=40110&msg_label=&am p;target_rec=0&class_size=" onMouseOver="window.status='Midterm Grades'; return true" onFocus="window.status='Midterm Grades'; return true" onMouseOut="window.status=''; return true"onBlur="window.status=''; return true">W</A></SPAN></TD> >Dana, > >I think the problem is that we're having a hard time envisioning it. >Can you post a snippet of the html? That would give us a better idea >of what you're wanting to do. If that's not possible, all I can say >is that I use ruby regularly to parse through xml/html files and grab >just the data I need. Something may be possible in CF that's similar. > The process I use is to grab the html file (and equivalent cfhttp) >and then parse the document as an xml file (a stronger version of >xmlparse). Then you can use xpath expressions to get at the data. > > >On 4/29/07, Dana Tierney <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:233504 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
