Re: Regex to strip out non-numerics but leave decimal point

2011-01-19 Thread Nando
should be good to go. From: Nando d.na...@gmail.com Sent: Tuesday, January 18, 2011 2:09 PM To: cf-talk cf-talk@houseoffusion.com Subject: Regex to strip out non-numerics but leave decimal point I'm trying to strip out all non-numeric

Regex to strip out non-numerics but leave decimal point

2011-01-18 Thread Nando
I'm trying to strip out all non-numeric characters from some fields. The catch is I need the regex to leave in the decimal point, cuz these are rates that include cents. rereplace(rc.hourlyRateInvoicedToClient,'[^[:digit:]]','','all') I'm not sure how to work something like [^\.] into it. Can

re: Regex to strip out non-numerics but leave decimal point

2011-01-18 Thread Jason Fisher
-talk@houseoffusion.com Subject: Regex to strip out non-numerics but leave decimal point I'm trying to strip out all non-numeric characters from some fields. The catch is I need the regex to leave in the decimal point, cuz these are rates that include cents. rereplace

Re: Regex to strip out non-numerics but leave decimal point

2011-01-18 Thread Nando
. From: Nando d.na...@gmail.com Sent: Tuesday, January 18, 2011 2:09 PM To: cf-talk cf-talk@houseoffusion.com Subject: Regex to strip out non-numerics but leave decimal point I'm trying to strip out all non-numeric characters from some fields. The catch is I need the regex to leave

Re: Regex to strip out non-numerics but leave decimal point

2011-01-18 Thread Nathan Strutz
, January 18, 2011 2:09 PM To: cf-talk cf-talk@houseoffusion.com Subject: Regex to strip out non-numerics but leave decimal point I'm trying to strip out all non-numeric characters from some fields. The catch is I need the regex to leave in the decimal point, cuz these are rates that include cents