I looked at it and it would probably work, but I had the other one working so I didn't try it.
Regards Dale Fraser From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Monday, 24 November 2008 5:36 PM To: [email protected] Subject: [cfaussie] Re: Pull apart a html table Did you try the function i sent? _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Monday, 24 November 2008 5:31 PM To: [email protected] Subject: [cfaussie] Re: Pull apart a html table Yep, Worked that out also, this seems to work for me, just need an inner loop over the cells. <cfloop condition="#reFindNoCase('<tr>.*?</tr>', html, pos)#"> <cfset posArray = reFindNoCase('<tr>.*?</tr>', html, pos, true) /> <cfset pos = posArray.pos[1]+1 /> <cfset posStruct = {} /> <cfset posStruct.pos = posArray.pos[1] /> <cfset posStruct.len = posArray.len[1] /> <cfset arrayAppend(result, posStruct) /> </cfloop> Regards Dale Fraser http://learncf.com <http://learncf.com/> http://flexcf.com <http://flexcf.com/> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Monday, 24 November 2008 5:29 PM To: [email protected] Subject: [cfaussie] Re: Pull apart a html table By the way with this regular expression all you will get is the first and last row because you are looking for anything that is not a ">" with anything inbetween ending in "</tr>" so it end up getting the whole table _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Monday, 24 November 2008 4:32 PM To: [email protected] Subject: [cfaussie] Re: Pull apart a html table I just need to get the content out, I know there is a fixed format to the tables, each row has three cells, and I need to extract the info from each cell and populate a database. I've been playing at regex to get all the rows to start with but having trouble, I have <cfset result = reFind("<tr[^>]*>(.*?)</tr>", html, 1, true) /> <cfdump var="#result#" /> But it only returns 2 elements in the array and there are hundreds of rows. Regards Dale Fraser http://learncf.com <http://learncf.com/> http://flexcf.com <http://flexcf.com/> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Monday, 24 November 2008 4:24 PM To: [email protected] Subject: [cfaussie] Re: Pull apart a html table what are you wanting to do with them? _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Monday, 24 November 2008 4:19 PM To: [email protected] Subject: [cfaussie] Pull apart a html table Is there an easy way to pull apart an html table. I have a heap of html where I need to loop through the html and get a specific table and then loop over the rows and columns. I could write all that code, but I feel like I would be reinventing the wheel, is this something that could be done with a regex or outside the scope? Regards Dale Fraser http://learncf.com <http://learncf.com/> http://flexcf.com <http://flexcf.com/> <BR <BR <BR --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
