Hmmm. Yup.
Expanding the function's context, this snippet proves your point:
CLS
SET VAR vNameFirst TEXT = NULL
SET VAR vNameMI TEXT = NULL
SET VAR vNameLast TEXT = NULL
SET VAR vHumpty TEXT = NULL
SET VAR vNameFirst = 'George'
SET VAR vNameLast = 'Patton'
SET VAR vHumpty = (.vNameFirst & (IFEXISTS(.vNameMI,'S ',.vNameMI)) +
.vNameLast)
SHOW VAR vHumpty
RETURN
Returns 'George Patton'.
Thanks for nudging.
Bruce
On 2015-12-06 19:59, Javier Valencia wrote:
Isn't it the same thing? AFAIK, null and "-0-" are one and the same.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bruce
A.
Chitiea
Sent: Sunday, December 06, 2015 5:01 PM
To: [email protected]
Subject: [RBASE-L] - RE: IFEXISTS Arg3 "Equals Nothing"
Javier:
Must be a slow Sunday at the Valencia homestead.
Same here. So here goes:
SET VAR vNothing TEXT = NULL
SET VAR vHumpty TEXT = NULL
SET VAR vHumpty = (IFEXISTS(.vNothing,'Nothing Exists',.vNothing)) SHOW
VAR
vHumpty RETURN
Returns the current NULL string: '-0-'.
I'm going with Razzak's suggestion.
Cheers!
Bruce
909.238.9012 mobile
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Javier
Valencia
Sent: Sunday, December 06, 2015 9:20 AM
To: [email protected]
Subject: [RBASE-L] - RE: IFEXISTS Arg3 "Equals Nothing"
Bruce ,
Would using the first argument as the third argument leave it
unchanged,
i.e. non-existent?
(IFEXISTS(TextArg1,TextArg2, TextArg1))
Just a thought and I have not tested it...
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bruce
Sent: Saturday, December 05, 2015 11:32 AM
To: [email protected]
Subject: [RBASE-L] - IFEXISTS Arg3 "Equals Nothing"
All:
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 Chitiea
SafeSectors, Inc.
909.238.9012 mobile
