You could add an XML declaration and parse it into an XML object. You'll
still have to find the table in the HTML though.
Blair
On Mon, Nov 24, 2008 at 4:45 PM, Steve Onnis <[EMAIL PROTECTED]> wrote:
>
> Would it be easier for you to convert it to a CSV format and process it
> from
> there?
>
>
>
> <cfscript>
>
> function TableToCSV () {
> var table = arguments[1];
>
> table = REReplaceNoCase(table, "[^[:print:]]", "", "ALL");
> table = replaceNocase(table, "</tr><tr>", chr(10), "ALL");
> table = replaceNoCase(table, "</td><td>", """,""", "ALL");
> table = replaceNoCase(table, "<td>", """", "ALL");
> table = replaceNoCase(table, "</td>", """", "ALL");
> table = REReplaceNoCase(table,
> "<(table|tbody|thead|tfoot|tr)([^>]*)>", "", "ALL");
> table = REReplaceNoCase(table,
> "</(table|tbody|thead|tfoot|tr)([^>]*)>", "", "ALL");
> return table;
> }
>
> </cfscript>
>
> <cfsavecontent variable="table">
> <table>
> <tr>
> <td>Cell 1.1</td>
> <td>Cell 1.2</td>
> <td>Cell 1.3</td>
> <td>Cell 1.4</td>
> </tr>
> <tr>
> <td>Cell 2.1</td>
> <td>Cell 2.2</td>
> <td>Cell 2.3</td>
> <td>Cell 2.4</td>
> </tr>
> </table>
> </cfsavecontent>
> <cfoutput>
> <pre>#HTMLEditFormat(TableToCSV(table))#</pre>
> </cfoutput>
>
>
>
> ________________________________
>
> 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
>
>
>
>
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
