> not sure how to strip out the non numbers from the form field? > do u off hand know of any articles or tuts on it??
This will strip out anything but numbers and periods. You will probably want to also test for multiple periods before inserting, and possibly the number of digits after the period as well to ensure valid data. <cfset field = "$1,000.00"> <cfset field = rereplace(field, "[^0-9|.]", "", "all")> <cfoutput>#field#</cfoutput> Result: 1000.00 -Justin Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
