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:353457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
