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
