Recommend not reinventing the wheel here: http://www.cflib.org/udf/NumberUnFormat
On 14 December 2012 14:59, Paul Giesenhagen <[email protected]> wrote: > > Heya, > > I know that some will know this quickly ... but I have ReplaceNoCase(str, > "[^0-9\.]","","ALL") > > And this takes -5 to 5 ... which is not what I want - I want to include > negative numbers what do I add to this regular expression to keep the > decimals (if there) and keep the negative if there? > > So > 5.24 is fine > -5.24 is fine > 5 is fine > -5 if fine > > $5.24 (replace the $) > $5,244.22 (replace the $ and the ,) > > Basically I need positive and negative integers to go into a float column. > > Thanks > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
