At 12:31 PM 12/5/2015, Bruce wrote:
How does one specify "nothing" as the arg3 "value" in an IFEXISTS function?
(IFEXISTS(TextArg1,TextArg2, ??? ))
(IFEXISTS(TextArg1,TextArg2, ' ' )) --<Space>
...introduces an unwanted <space>. TRIM cannot be applied in my
specific circumstance.
(IFEXISTS(TextArg1,TextArg2, '' )) --No <space>
...produces error message 2155: "The first and last two arguments
for IFEXISTS must
be the same type."
Can't say I've ever asked R:BASE to do nothing.
Bruce,
Use the keyword NULL and see what you get.
(IFEXISTS(TextArg1,TextArg2,NULL))
Very Best R:egards,
Razzak
