Title: RE: [cfaussie] Re: Budget CF Server
Hey Lindsay, what a champion!
 
If you ever come up to Newcastle let me know and I'll buy you a beer.
 
Thanks,
Phil.
----- Original Message -----
Sent: Friday, February 28, 2003 3:45 PM
Subject: [cfaussie] Re: Zero suppression

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 -----
Newsgroups: cfaussie
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/
---
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/

Reply via email to