try this
Var = whatever:
Var = iif( Var==0,null,Var);
--
Cheers
Graham
AB-Write >< Professional AFL Writing Service
Yes, I write AFL code to your requirements
http://www.aflwriting.com
On 16/11/06, dchang813 <[EMAIL PROTECTED]> wrote:
Hi--
I'm looking for the converse of the NZ() function--in other words, I'd
like to turn all zeroes in an array to Null.
For instance, given an array of:
1 0 0 1 1 0 1
I'd like to turn it into:
1 Null Null 1 1 Null 1
Why? I'd like to be able to create a "mask" array that can be used to
cut holes in an otherwise continuous indicator.
So, say the indicator's array is:
33.54 33.51 33.50 33.53 33.49 33.40 33.30
Doing a bitwise & on this array and the mask I gave above would produce:
33.54 Null Null 33.53 33.49 Null 33.30
The plot would then show line segments connecting these points (or so
I hope).
Can this be done without looping through the mask array to replace the
zeros with Nulls?
Thanks,
Dennis.
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
