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