I just get nothing. Proof positive that R:BASE can do anything, including nothing.
Muchas gracias, senor Memon! Bruce Chitiea El Presidente, Cocinero Lavadora de Botellas SafeSectors, Inc. 909.238.9012 mobile -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Saturday, December 05, 2015 9:44 AM To: [email protected] Subject: [RBASE-L] - Re: IFEXISTS Arg3 "Equals Nothing" 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
