Hi All,I have a CF function to clean HTML content before displying it in browser.Function is returing proper results when I pass less amount of HTML data, however it fails for large data.<cffunction name="cleanHTML" returntype="string"><cfargument name="sHTML" type="string" required="yes"><cfset sHTML = reReplace(sHTML, "\r\n(\S?)", "\1", "all")><cfset sHTML = reReplaceNoCase(sHTML, " \s*(<(u|o)l>)", "\1", "all")><cfset sHTML = reReplaceNoCase(sHTML, "</?(p)>", "", "all")><cfset sHTML = reReplaceNoCase(sHTML, "(\s+| +)*( (\s+| +)*)+$", "", "all")><cfreturn sHTML></cffunction><cfquery name="getReport" datasource="pdd_v2" >SELECT highlights, details FROM project_reports WHERE project_id = 71082</cfquery><cfoutput>#cleanHTML(getReport.details)#</cfoutput>HTML data that I am trying to pass(getReport.details) to above function is given below,<table width="100%" cellspacing="0" cellpadding="0" border="0" style="width: 100%;" class="MsoNormalTable"><tbody><tr style=""><td style="padding: 1.5pt 3.75pt;">Type:</td><td style="padding: 1.5pt 3.75pt;" colspan="3">Monthly </td></tr><tr style="height: 11.25pt;"><td width="80" style="width: 60pt; padding: 1.5pt 3.75pt; height: 11.25pt;">Month:</td><td style="padding: 1.5pt 3.75pt; height: 11.25pt;">November</td><td width="7%" style="width: 7%; padding: 1.5pt 3.75pt; height: 11.25pt;">Year:</td><td style="padding: 1.5pt 3.75pt; height: 11.25pt;">2010</td></tr><tr style=""><td style="padding: 1.5pt 3.75pt;" colspan="4"> </td></tr><tr style="height: 11.25pt;"><td width="120" valign="top" style="width: 90pt; padding: 1.5pt 3.75pt; height: 11.25pt;">Highlights: (appears on Monthly / Watchlist reports)</td><td valign="top" style="padding: 1.5pt 3.75pt; height: 11.25pt;" colspan="3">1. Change Point Algorithm: work on-going2. Sebastien completed his Advance Project3. Evaluated the Fluid Displacement Module from Goeservices Next Major Milestone: Feasibility Closure</td></tr><tr style=""><td style="padding: 1.5pt 3.75pt;" colspan="4"> </td></tr><tr style="height: 11.25pt;"><td width="120" valign="top" style="width: 90pt; padding: 1.5pt 3.75pt; height: 11.25pt;">Details: (only appears on detailed monthly report)</td><td valign="top" style="padding: 1.5pt 3.75pt; height: 11.25pt;" colspan="3">Major Achievements of the month: <table cellspacing="0" cellpadding="0" border="1" style="border-collapse: collapse; border: medium none;" class="MsoNormalTable"><tbody><tr style="height: 24.25pt;"><td valign="top" style="border: 1pt solid windowtext; padding: 0mm 5.4pt; height: 24.25pt;">1</td><td width="442" valign="top" style="width: 331.5pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt; height: 24.25pt;">Change Point Algorithm– Work on Matlab interpretation code.</td></tr><tr style="height: 24.25pt;"><td valign="top" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0mm 5.4pt; height: 24.25pt;">2</td><td width="442" valign="top" style="width: 331.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt; height: 24.25pt;">Sebastien completed his Advance Project– Sebastien demonstrated that the attenuation of the optical signal noticed in the ITP fiber coil while cement was setting was not related to any simple fiber layout but was either due to the specific coiling process used with ITP or to a change to the silica optical index due to the cement setting reaction.</td></tr><tr style="height: 24.25pt;"><td valign="top" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0mm 5.4pt; height: 24.25pt;">3</td><td width="442" valign="top" style="width: 331.5pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt; height: 24.25pt;">Evaluated the Fluid Displacement Module from Goeservices– The Fluid Displacement Module (FDM) from Geoservices is the only software application that can handle the u-tube phenomenon experienced during cementing operations. FDM uses an empirical setting to manage the u-tube, and although it provides a first assessment of the u-tube duration, it is not sufficient for a quantitative analysis.</td></tr></tbody></table> Tests – Qualifications: <table width="461" cellspacing="0" cellpadding="0" border="1" style="width: 345.95pt; border-collapse: collapse; border: medium none;" class="MsoNormalTable"><tbody><tr style=""><td width="108" valign="top" style="width: 80.75pt; border: 1pt solid windowtext; padding: 0mm 5.4pt;">Planned Tests</td><td width="354" valign="top" style="width: 265.2pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td></tr><tr style=""><td width="108" valign="top" style="width: 80.75pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0mm 5.4pt;">Ongoing Tests</td><td width="354" valign="top" style="width: 265.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td></tr><tr style=""><td width="108" valign="top" style="width: 80.75pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0mm 5.4pt;">Completed Tests</td><td width="354" valign="top" style="width: 265.2pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td></tr></tbody></table> Failures:N/A Major issues:N/A Closed issues:N/A Major Project Changes:N/A Team Members: <table cellspacing="0" cellpadding="0" border="1" style="border-collapse: collapse; border: medium none;" class="MsoNormalTable"><tbody><tr style=""><td width="75" valign="top" style="width: 56.2pt; border: 1pt solid windowtext; padding: 0mm 5.4pt;">Name</td><td width="81" valign="top" style="width: 60.7pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Function</td><td width="46" valign="top" style="width: 34.55pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Elec</td><td width="56" valign="top" style="width: 42.15pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Mec</td><td width="46" valign="top" style="width: 34.8pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Firm</td><td width="46" valign="top" style="width: 34.55pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Soft</td><td width="51" valign="top" style="width: 38.3pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Physics</td><td width="68" valign="top" style="width: 50.65pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Other</td></tr><tr style=""><td width="75" valign="top" style="width: 56.2pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0mm 5.4pt;">Nicolas Flamant</td><td width="81" valign="top" style="width: 60.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Project Manager</td><td width="46" valign="top" style="width: 34.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td><td width="56" valign="top" style="width: 42.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td><td width="46" valign="top" style="width: 34.8pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td><td width="46" valign="top" style="width: 34.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">X</td><td width="51" valign="top" style="width: 38.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td><td width="68" valign="top" style="width: 50.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td></tr><tr style=""><td width="75" valign="top" style="width: 56.2pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0mm 5.4pt;">Sebastien Morellet</td><td width="81" valign="top" style="width: 60.7pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">Development engineer</td><td width="46" valign="top" style="width: 34.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td><td width="56" valign="top" style="width: 42.15pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td><td width="46" valign="top" style="width: 34.8pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td><td width="46" valign="top" style="width: 34.55pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;">X</td><td width="51" valign="top" style="width: 38.3pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td><td width="68" valign="top" style="width: 50.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0mm 5.4pt;"> </td></tr></tbody></table> Project Needs – Questions:N/A </td></tr><tr style="height: 11.25pt;"><td width="120" valign="top" style="width: 90pt; padding: 1.5pt 3.75pt; height: 11.25pt;">Version 1.0</td><td valign="top" style="padding: 1.5pt 3.75pt; height: 11.25pt;" colspan="3">P. Parent - 5 Feb. 2008</td></tr></tbody></table> Can anybody please help me to fine tune this function (or) provide me if you have any better function to do this.Thanks in advance.Regars,Manoz

A

Anonymous

Question

Query on REReplace function to clean HTML content.

Forum|Forum|15 years ago
December 9, 2010
2 replies
1359 views

Hi All,

I have a CF function to clean HTML content before displying it in browser.
Function is returing proper results when I pass less amount of HTML data, however it fails for large data.

<cfquery name="getReport" datasource="pdd_v2" >
SELECT highlights, details FROM project_reports WHERE project_id = 71082
</cfquery>

<cfoutput>#cleanHTML(getReport.details)#</cfoutput>

HTML data that I am trying to pass(getReport.details) to above function is given below,

<!--[if gte mso 9]><xml>

<o:DocumentProperties>

<o:Version>12.00</o:Version>

</o:DocumentProperties>

</xml><![endif]--><!--[if gte mso 9]><xml>

<w:WordDocument>

<w:View>Normal</w:View>

<w:Zoom>0</w:Zoom>

<w:TrackMoves />

<w:TrackFormatting />

<w:DoNotShowRevisions />

<w:DoNotPrintRevisions />

<w:DoNotShowComments />

<w:DoNotShowInsertionsAndDeletions />

<w:DoNotShowPropertyChanges />

<w:PunctuationKerning />

<w:ValidateAgainstSchemas />

<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>

<w:IgnoreMixedContent>false</w:IgnoreMixedContent>

<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>

<w:DoNotPromoteQF />

<w:LidThemeOther>EN-US</w:LidThemeOther>

<w:LidThemeAsian>X-NONE</w:LidThemeAsian>

<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>

<w:Compatibility>

<w:BreakWrappedTables />

<w:SnapToGridInCell />

<w:WrapTextWithPunct />

<w:UseAsianBreakRules />

<w:DontGrowAutofit />

<w:SplitPgBreakAndParaMark />

<w:DontVertAlignCellWithSp />

<w:DontBreakConstrainedForcedTables />

<w:DontVertAlignInTxbx />

<w:Word11KerningPairs />

<w:CachedColBalance />

</w:Compatibility>

<m:mathPr>

<m:mathFont m:val="Cambria Math" />

<m:brkBin m:val="before" />

<m:brkBinSub m:val="--" />

<m:smallFrac m:val="off" />

<m:dispDef />

<m:lMargin m:val="0" />

<m:rMargin m:val="0" />

<m:defJc m:val="centerGroup" />

<m:wrapIndent m:val="1440" />

<m:intLim m:val="subSup" />

<m:naryLim m:val="undOvr" />

</m:mathPr></w:WordDocument>

</xml><![endif]--><!--[if gte mso 9]><xml>

<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"

DefSemiHidden="true" DefQFormat="false" DefPriority="99"

LatentStyleCount="267">

<w:LsdException Locked="false" Priority="0" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Normal" />

<w:LsdException Locked="false" Priority="9" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="heading 1" />

<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2" />

<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3" />

<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4" />

<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5" />

<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6" />

<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7" />

<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8" />

<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9" />

<w:LsdException Locked="false" Priority="39" Name="toc 1" />

<w:LsdException Locked="false" Priority="39" Name="toc 2" />

<w:LsdException Locked="false" Priority="39" Name="toc 3" />

<w:LsdException Locked="false" Priority="39" Name="toc 4" />

<w:LsdException Locked="false" Priority="39" Name="toc 5" />

<w:LsdException Locked="false" Priority="39" Name="toc 6" />

<w:LsdException Locked="false" Priority="39" Name="toc 7" />

<w:LsdException Locked="false" Priority="39" Name="toc 8" />

<w:LsdException Locked="false" Priority="39" Name="toc 9" />

<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption" />

<w:LsdException Locked="false" Priority="10" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Title" />

<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font" />

<w:LsdException Locked="false" Priority="11" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Subtitle" />

<w:LsdException Locked="false" Priority="0" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Strong" />

<w:LsdException Locked="false" Priority="20" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Emphasis" />

<w:LsdException Locked="false" Priority="0" Name="Normal (Web)" />

<w:LsdException Locked="false" Priority="59" SemiHidden="false"

UnhideWhenUsed="false" Name="Table Grid" />

<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text" />

<w:LsdException Locked="false" Priority="1" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="No Spacing" />

<w:LsdException Locked="false" Priority="60" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Shading" />

<w:LsdException Locked="false" Priority="61" SemiHidden="false"

UnhideWhenUsed="false" Name="Light List" />

<w:LsdException Locked="false" Priority="62" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Grid" />

<w:LsdException Locked="false" Priority="63" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 1" />

<w:LsdException Locked="false" Priority="64" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 2" />

<w:LsdException Locked="false" Priority="65" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 1" />

<w:LsdException Locked="false" Priority="66" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 2" />

<w:LsdException Locked="false" Priority="67" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 1" />

<w:LsdException Locked="false" Priority="68" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 2" />

<w:LsdException Locked="false" Priority="69" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 3" />

<w:LsdException Locked="false" Priority="70" SemiHidden="false"

UnhideWhenUsed="false" Name="Dark List" />

<w:LsdException Locked="false" Priority="71" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Shading" />

<w:LsdException Locked="false" Priority="72" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful List" />

<w:LsdException Locked="false" Priority="73" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Grid" />

<w:LsdException Locked="false" Priority="60" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Shading Accent 1" />

<w:LsdException Locked="false" Priority="61" SemiHidden="false"

UnhideWhenUsed="false" Name="Light List Accent 1" />

<w:LsdException Locked="false" Priority="62" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Grid Accent 1" />

<w:LsdException Locked="false" Priority="63" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1" />

<w:LsdException Locked="false" Priority="64" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1" />

<w:LsdException Locked="false" Priority="65" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 1 Accent 1" />

<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision" />

<w:LsdException Locked="false" Priority="34" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="List Paragraph" />

<w:LsdException Locked="false" Priority="29" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Quote" />

<w:LsdException Locked="false" Priority="30" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Intense Quote" />

<w:LsdException Locked="false" Priority="66" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 2 Accent 1" />

<w:LsdException Locked="false" Priority="67" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1" />

<w:LsdException Locked="false" Priority="68" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1" />

<w:LsdException Locked="false" Priority="69" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1" />

<w:LsdException Locked="false" Priority="70" SemiHidden="false"

UnhideWhenUsed="false" Name="Dark List Accent 1" />

<w:LsdException Locked="false" Priority="71" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Shading Accent 1" />

<w:LsdException Locked="false" Priority="72" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful List Accent 1" />

<w:LsdException Locked="false" Priority="73" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Grid Accent 1" />

<w:LsdException Locked="false" Priority="60" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Shading Accent 2" />

<w:LsdException Locked="false" Priority="61" SemiHidden="false"

UnhideWhenUsed="false" Name="Light List Accent 2" />

<w:LsdException Locked="false" Priority="62" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Grid Accent 2" />

<w:LsdException Locked="false" Priority="63" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2" />

<w:LsdException Locked="false" Priority="64" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2" />

<w:LsdException Locked="false" Priority="65" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 1 Accent 2" />

<w:LsdException Locked="false" Priority="66" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 2 Accent 2" />

<w:LsdException Locked="false" Priority="67" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2" />

<w:LsdException Locked="false" Priority="68" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2" />

<w:LsdException Locked="false" Priority="69" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2" />

<w:LsdException Locked="false" Priority="70" SemiHidden="false"

UnhideWhenUsed="false" Name="Dark List Accent 2" />

<w:LsdException Locked="false" Priority="71" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Shading Accent 2" />

<w:LsdException Locked="false" Priority="72" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful List Accent 2" />

<w:LsdException Locked="false" Priority="73" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Grid Accent 2" />

<w:LsdException Locked="false" Priority="60" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Shading Accent 3" />

<w:LsdException Locked="false" Priority="61" SemiHidden="false"

UnhideWhenUsed="false" Name="Light List Accent 3" />

<w:LsdException Locked="false" Priority="62" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Grid Accent 3" />

<w:LsdException Locked="false" Priority="63" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3" />

<w:LsdException Locked="false" Priority="64" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3" />

<w:LsdException Locked="false" Priority="65" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 1 Accent 3" />

<w:LsdException Locked="false" Priority="66" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 2 Accent 3" />

<w:LsdException Locked="false" Priority="67" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3" />

<w:LsdException Locked="false" Priority="68" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3" />

<w:LsdException Locked="false" Priority="69" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3" />

<w:LsdException Locked="false" Priority="70" SemiHidden="false"

UnhideWhenUsed="false" Name="Dark List Accent 3" />

<w:LsdException Locked="false" Priority="71" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Shading Accent 3" />

<w:LsdException Locked="false" Priority="72" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful List Accent 3" />

<w:LsdException Locked="false" Priority="73" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Grid Accent 3" />

<w:LsdException Locked="false" Priority="60" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Shading Accent 4" />

<w:LsdException Locked="false" Priority="61" SemiHidden="false"

UnhideWhenUsed="false" Name="Light List Accent 4" />

<w:LsdException Locked="false" Priority="62" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Grid Accent 4" />

<w:LsdException Locked="false" Priority="63" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4" />

<w:LsdException Locked="false" Priority="64" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4" />

<w:LsdException Locked="false" Priority="65" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 1 Accent 4" />

<w:LsdException Locked="false" Priority="66" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 2 Accent 4" />

<w:LsdException Locked="false" Priority="67" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4" />

<w:LsdException Locked="false" Priority="68" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4" />

<w:LsdException Locked="false" Priority="69" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4" />

<w:LsdException Locked="false" Priority="70" SemiHidden="false"

UnhideWhenUsed="false" Name="Dark List Accent 4" />

<w:LsdException Locked="false" Priority="71" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Shading Accent 4" />

<w:LsdException Locked="false" Priority="72" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful List Accent 4" />

<w:LsdException Locked="false" Priority="73" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Grid Accent 4" />

<w:LsdException Locked="false" Priority="60" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Shading Accent 5" />

<w:LsdException Locked="false" Priority="61" SemiHidden="false"

UnhideWhenUsed="false" Name="Light List Accent 5" />

<w:LsdException Locked="false" Priority="62" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Grid Accent 5" />

<w:LsdException Locked="false" Priority="63" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5" />

<w:LsdException Locked="false" Priority="64" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5" />

<w:LsdException Locked="false" Priority="65" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 1 Accent 5" />

<w:LsdException Locked="false" Priority="66" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 2 Accent 5" />

<w:LsdException Locked="false" Priority="67" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5" />

<w:LsdException Locked="false" Priority="68" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5" />

<w:LsdException Locked="false" Priority="69" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5" />

<w:LsdException Locked="false" Priority="70" SemiHidden="false"

UnhideWhenUsed="false" Name="Dark List Accent 5" />

<w:LsdException Locked="false" Priority="71" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Shading Accent 5" />

<w:LsdException Locked="false" Priority="72" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful List Accent 5" />

<w:LsdException Locked="false" Priority="73" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Grid Accent 5" />

<w:LsdException Locked="false" Priority="60" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Shading Accent 6" />

<w:LsdException Locked="false" Priority="61" SemiHidden="false"

UnhideWhenUsed="false" Name="Light List Accent 6" />

<w:LsdException Locked="false" Priority="62" SemiHidden="false"

UnhideWhenUsed="false" Name="Light Grid Accent 6" />

<w:LsdException Locked="false" Priority="63" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6" />

<w:LsdException Locked="false" Priority="64" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6" />

<w:LsdException Locked="false" Priority="65" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 1 Accent 6" />

<w:LsdException Locked="false" Priority="66" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium List 2 Accent 6" />

<w:LsdException Locked="false" Priority="67" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6" />

<w:LsdException Locked="false" Priority="68" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6" />

<w:LsdException Locked="false" Priority="69" SemiHidden="false"

UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6" />

<w:LsdException Locked="false" Priority="70" SemiHidden="false"

UnhideWhenUsed="false" Name="Dark List Accent 6" />

<w:LsdException Locked="false" Priority="71" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Shading Accent 6" />

<w:LsdException Locked="false" Priority="72" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful List Accent 6" />

<w:LsdException Locked="false" Priority="73" SemiHidden="false"

UnhideWhenUsed="false" Name="Colorful Grid Accent 6" />

<w:LsdException Locked="false" Priority="19" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis" />

<w:LsdException Locked="false" Priority="21" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis" />

<w:LsdException Locked="false" Priority="31" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference" />

<w:LsdException Locked="false" Priority="32" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Intense Reference" />

<w:LsdException Locked="false" Priority="33" SemiHidden="false"

UnhideWhenUsed="false" QFormat="true" Name="Book Title" />

<w:LsdException Locked="false" Priority="37" Name="Bibliography" />

<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading" />

</w:LatentStyles>

</xml><![endif]--><!--[if gte mso 10]>

<style>

/* Style Definitions */

table.MsoNormalTable

{mso-style-name:"Table Normal";

mso-tstyle-rowband-size:0;

mso-tstyle-colband-size:0;

mso-style-noshow:yes;

mso-style-priority:99;

mso-style-qformat:yes;

mso-style-parent:"";

mso-padding-alt:0mm 5.4pt 0mm 5.4pt;

mso-para-margin:0mm;

mso-para-margin-bottom:.0001pt;

mso-pagination:widow-orphan;

font-size:10.0pt;

font-family:"Times New Roman","serif";}

</style>

<![endif]-->

<tbody>

Type:

</td>

Monthly

</td>

</tr>

Month:

</td>

November

</td>

Year:

</td>

2010

</td>

</tr>

</td>

</tr>

Highlights:

(appears on Monthly / Watchlist reports)

</td>

1. Change Point Algorithm: work on-going

2. Sebastien completed his Advance Project

3. Evaluated the Fluid Displacement Module from Goeservices

Next Major Milestone: Feasibility Closure

</td>

</tr>

</td>

</tr>

Details:

(only appears on detailed monthly report)

</td>

Major Achievements of the month:

<tbody>

1

</td>

Change Point Algorithm

– Work on Matlab interpretation code.

</td>

</tr>

2

</td>

Sebastien completed his Advance Project

– Sebastien demonstrated that the attenuation of the optical signal noticed in the ITP fiber coil while cement was setting was not related to any simple fiber layout but was either due to the specific coiling process used with ITP or to a change to the silica optical index due to the cement setting reaction.

</td>

</tr>

3

</td>

Evaluated the Fluid Displacement Module from Goeservices

– The Fluid Displacement Module (FDM) from Geoservices is the only software application that can handle the u-tube phenomenon experienced during cementing operations. FDM uses an empirical setting to manage the u-tube, and although it provides a first assessment of the u-tube duration, it is not sufficient for a quantitative analysis.

</td>

</tr>

</tbody>

</table>

Tests – Qualifications:

<tbody>

Planned Tests

</td>

</td>

</tr>

Ongoing Tests

</td>

</td>

</tr>

Completed Tests

</td>

</td>

</tr>

</tbody>

</table>

Failures:

N/A

Major issues:

N/A

Closed issues:

N/A

Major Project Changes:

N/A

Team Members:

<tbody>

Name

</td>

Function

</td>

Elec

</td>

Mec

</td>

Firm

</td>

Soft

</td>

Physics

</td>

Other

</td>

</tr>

Nicolas Flamant

</td>

Project Manager

</td>

</td>

</td>

</td>

X

</td>

</td>

</td>

</tr>

Sebastien Morellet

</td>

Development engineer

</td>

</td>

</td>

</td>

X

</td>

</td>

</td>

</tr>

</tbody>

</table>

Project Needs – Questions:

N/A

</td>

</tr>

Version 1.0

</td>

P. Parent - 5 Feb. 2008

</td>

</tr>

</tbody>

</table>

Can anybody please help me to fine tune this function (or) provide me if you have any better function to do this.

Thanks in advance.

Regars,
Manoz

This topic has been closed for replies.

A

Adam Cameron.

Inspiring

If you just want to strip HTML out of a string, there's a function to do that on CFLib: http://www.cflib.org/udf/stripHTML. there's probably no need to reinvent the wheel.

One thing I notice with your regexes is that you're doing this sort of thing:

<cfset sHTML = reReplace(sHTML, "\r\n(\S?)", "\1", "all")>

If all you're wanting to do is to get rid of \r\n, then just do that. You don't need to also capture all the non-CRLF chars after it, and simply put them back in again afterwards. This is adding a substantial overhead to your processing, for no reason.

Just do this:

<cfset sHTML = reReplace(sHTML, "\r\n", "", "all")>

But unless there's a good reason not to, I'd just use the UDF from CFLib.

--

Adam

A

Anonymous

Adam,

Thanks for the response.

I dont want to strip HTML out of a string, existing HTML format should not get affected with our regular expression, it should just format the HTML content to to remove new lines, remove breaks before lists, get rid of paragraph tags, get rid of trailing line breaks.

I tried with your example, but it is displaying the output by removing all HTML tags.

I modified my CF function to cfscript function like below, still same problem is occuring. page gets stuck and it takes long time.

<cfscript>
function stripHTML(sHTML)
{
 // Remove new lines from html
 sHTML = reReplace(sHTML, "\r\n(\S?)", "\1", "all");
 // Remove breaks before lists eg <ol>
 sHTML = reReplaceNoCase(sHTML, " \s*(<(u|o)l>)", "\1", "all");
 // Get rid of paragraph tags
 sHTML = reReplaceNoCase(sHTML, "</?(p)>", "", "all");
 // Get rid of trailing line breaks (including white space and forces spaces
 sHTML = reReplaceNoCase(sHTML, "(\s+| +)*( (\s+| +)*)+$", "", "all");
 return trim(sHTML);
}
</cfscript>

Can you please suggest me a solution?

- Manoz

A

Adam Cameron.

Inspiring

I did suggest a solution, but you seem to not have read it. Ignore the first and last para of my previous response - ie: ignore the suggestion about the CFLib thing - and read the rest of it.

--

Adam

M

meensi

Inspiring

Hi Manoz,

Just a thought, can we split the input file as a small ones and pass it to this function.

If you have 1000 lines, splitted into two and pass it to this function.

I haven't done this.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded