> From: Les Mizzell [mailto:[EMAIL PROTECTED] > Trying to turn $123,456 into 123456 > Getting rid of the "$" sign is easy... > #Replace(mynumber, "$", "", "ALL")# > But I'm not sure how to kill the "$" and the "," at the same > time with the least amount of fuss...
Les, I just solved the same problem for a form I was working on. I needed to strip out anything EXCEPT digits and a period. I used the following: var _regEx = /[^0-9\.]*/g; var _br = document.offerLetterRequest.billRate.value; var _billRate = ( isNaN(parseFloat(_br.replace(_regEx,''))) ) ? 0.00 : parseFloat(_br.replace(_regEx,'')); You can take the above regex and use it in CF without too much difficulty. HTH, Tango ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235718 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
