Albert. I agree, I can not tell you the hours I spent in my years of programming because a variable is spelled wrong or not matching up. What I am suggesting is a function like rtrs - Retain Trailing Space (variable) that allows you to keep the trailing space in this instance of using the function. Not globally.
-- Frank Taylor, Information Technologies Administrator -- F.J. O'Hara Corp - Araho Transfer -- Boston, MA. Miami, FL -- [email protected] -- Direct Dial:617-790-3093 ________________________________________ From: [email protected] [[email protected]] on behalf of Albert Berry [[email protected]] Sent: Wednesday, March 25, 2015 11:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Adding a space to the end of a variable The trailing space was being automatically added in the forms/reports designers. It was a real pain working in the Forms area when a variable did not work because of the automatically added trailing space. In my case, I use stored procedures for anything that is used in more than one area of the system, and the trailing space was a hassle. Others had the same problem. I think we are into one of those situations where a solution for one area fouls up another. Albert On 3/25/2015 7:51 AM, Frank Taylor wrote: > Bob, > > As far as I know this issue of Trailing Spaces being dropped from variables > still exists. You can see on the list in July 2013 and as recent as Jan 2015 > this issue has been raised. Trailing spaces are always dropped from the end > of a variable. I am not sure if an enhancement request has been made for a > function to keep them. But if anyone has a working solution I would love to > implement it here. My workaround was to use an underscore. > > -- Frank Taylor, Information Technologies Administrator > -- F.J. O'Hara Corp - Araho Transfer -- Boston, MA. Miami, FL > -- [email protected] -- Direct Dial:617-790-3093 > ________________________________________ > From: [email protected] [[email protected]] on behalf of Clive Williams > [[email protected]] > Sent: Tuesday, March 24, 2015 7:53 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Adding a space to the end of a variable > > Hi Bob > > > > That is the ANSI character set – try 160 instead. > > > > Regards > > > > Clive Williams > > CRW-logo_small > > CRW Services > > PO Box 12 > > Springwood NSW 2777 > > > > Mobile: 0418 657 833 > > A H: (02) 4754 4151 > > Skype: crwservices > > email: [email protected] > > www.crwservices.com.au <http://www.crwservices.com.au/> > > > > Ostendo Consulting Partner > > MYOB Certified Consultant > > Intuit QuickBooks Online ProAdvisor > > Xero Certified Advisor > > Registered BAS Agent > > MYOB Accredited Trainer > > Cert IV Workplace Training & Assessment > > Cert IV Financial Services (Bookkeeping) > > Ostendo® adds advanced inventory, job costing, manufacturing, service and > distribution to your accounting system. > > > > This e-mail message and accompanying data may contain information that is > confidential and subject to legal professional privilege. If you are not the > intended recipient you are notified that any use, dissemination, distribution > or copying of this message or data is prohibited. All content is to be > treated as confidential unless otherwise specified, and is not to be > forwarded to third parties without the prior permission of the author. If you > have received this e-mail message in error please delete it and notify the > sender. > > > > Although this message has been checked for viruses, it is the responsibility > of the addressee to scan this message for viruses also. > > Neither Clive Williams nor CRW Services warrant that the information herein > is free from any virus, defect or error. > > > > P PLEASE CONSIDER THE ENVIRONMENT BEFORE YOU PRINT THIS E-MAIL > > > > From: [email protected] [mailto:[email protected]] On Behalf Of Bob Thompson > Sent: Wednesday, 25 March 2015 10:02 > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Adding a space to the end of a variable > > > > I tried the 255, but got the "y" character at the R> on my PC. > > > > Thanks, > > > > Bob Thompson > > LaPorte, IN > > 219-363-7441 > > > > Sent from my iPod > > > On Mar 24, 2015, at 5:52 PM, Doug Hamilton <[email protected]> wrote: > > Bob, wasn't (CHAR(255)) a hard space? > > R> > set echo on > set var vtext = ('ABCD') > set var vText = (.vText + (CHAR(32)) ) > set v vlen inte = (SLEN(.vTEXT)) > sho var vtext > ABCD > sho var vlen > 4 > set var vtext = ('ABCD') > set var vText = (.vText + (CHAR(255)) ) > set v vlen inte = (SLEN(.vTEXT)) > sho var vtext > ABCDÿ > sho var vlen > 5 > ret > > Or maybe (CHAR(255)) was a smiley-Y, although it showed at the R>, pasted > above, as a blank; email client probably made it the smiley-Y. > Doug > > > > On 3/24/2015 4:43 PM, [email protected] wrote: > > This seems like it should be an easy task, but for some reason it is eluding > me. > > > > I need to add a space to the end of a text variable, such as : > > > > set var vText = (.vText + ' ') > > or > > set var vText = (.vText + (CHAR(32)) ) > > > > Neither of these add the space. > > > > It is probably staring me in the face and I just can't see it today! > > > > Thanks, > > Bob > > > > > --- RBASE-L > =======================3D=======================3 > D= > TO POST A MESSAGE TO ALL MEMBERS: > Send a plain text email to [email protected] > > (Don't use any of these words as your Subject: > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > =======================3D=======================3 > D= > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: INTRO > =======================3D=======================3 > D= > TO UNSUBSCRIBE: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: UNSUBSCRIBE > =======================3D=======================3 > D= > TO SEARCH ARCHIVES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: SEARCH-n > (where n is the number of days). In the message body, > place any > text to search for. > =======================3D=======================3 > D= > > > -- A democracy ..." can only exist until the majority discovers it can vote itself largess out of the public treasury." Attributed to Alexander Fraser Tytler 1747-1813
