[cfaussie] Re: Zero suppression

[Lindsay Evans]

Title: RE: [cfaussie] Re: Budget CF Server

Totally untested, but:   REReplace(var, "^0$", "")     only 1 1/4 hrs til beer o'clock!   --  Lindsay Evans.  Developer,  Red Square Productions.  [p] 8596.4000  [f] 8596.4001  [w] www.redsquare.com.au -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Phil Evans Sent: Friday, February 28, 2003 3:29 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Zero suppression I had thought that would change 10 to 1, which I don't want.   Any non-zero number needs to be unchanged.   I suppose I could try rereplace if I could just figure out the reg exp for a single zero digit.   Thanks, Phil. ----- Original Message ----- From: Phil McCluskey Newsgroups: cfaussie To: CFAussie Mailing List Sent: Friday, February 28, 2003 3:22 PM Subject: [cfaussie] Re: Zero suppression can't you just use replace(variable, '0','')? "Phil Evans" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... Hi All,   The other day we had some very clever methods for converting negatives to zero. Any one care to have a crack at converting zero to null, prior to displaying on a form? (Aside from using an IF statement).   Thanks, Phil.     --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/