PureBytes Links
Trading Reference Links
|
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.
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.11/542 - Release Date: 11/20/2006
|