Good deal ... thank you! -----Original Message----- From: Adam Cameron [mailto:adamcameroncoldfus...@gmail.com] Sent: Friday, December 14, 2012 9:28 AM To: cf-talk Subject: Re: Regular Expression - decimal number positive & negative
Recommend not reinventing the wheel here: http://www.cflib.org/udf/NumberUnFormat On 14 December 2012 14:59, Paul Giesenhagen <p...@quilldesign.com> 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:353469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm