Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Generalxf_GeneralGeneral Functions
Public Function nze (
varToTest As Variant,
Optional varIfMt As Variant = Null
) As Variant
Like the built in nz() function, but substitutes second value if mt() is true.
varToTest as Variant
A variant value
Optional varIfMt as Variant = Null
The empty substitution value
Call Template:
Dim v As Variant
v = xf.Gen.nze(varToTest)
v = xf.Gen.nze(varToTest, varIfMt)
See Also:
Example 1:
nze(Null, "suprise!") => suprise!
nze("", "suprise!") => suprise!
nze("0", "suprise!") => 0 (string)
nze(0, -1) => 0
nze(23, -1) => 23
nze(False, "suprise!") => False