I need to run this on our CF5 server: I have some large text fields containing HTML, most of which have some variation of the following HTML snippet at the beginning:
<b><i>Some text</i></b> More text and HTML follows... <i><b>Some more text</i></b> More text and HTML follows... <i><b>Yet some more text</b></i> More text and HTML follows... I need a regex that will let me extract and remove the leading text so that it can be stored in a separate column. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

