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
