>On 2/14/06, Charlie Griefer wrote: > >that regex will remove anything that's not a number or a decimal point. > >so yes, on INSERT/UPDATE, use the regex to insert only numeric values. >
Mmmm...I just tested it, and this is what it does: - if there are several spaces followed by a number, it strips the spaces and gets the number; - if there is a comma, it strips the comma and gets the numbers; - if there are only spaces, it throws an error; - if there is text (e.g., "n/a"), it throws an error. Anything that can be added to the "rereplace" code to account for text/additional characters? Thanks, Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
