I've been working around this one since day one with RBASE. It is a feature which helps avoid trailing spaces in table data. It actually saves a huge amount of coding by avoiding having to use TRIM on all text data going in the DB. A little creative thinking usually handles this without resorting to "magic" characters which can get you into trouble too.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Monday, July 01, 2013 4:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SGET, Variables and Trailing <Space> Then one workaround might be to: 1. SRPL all the <space>s in the field with something unique, 2. SRPL the converted target string 3. SRPL the desired <space>s back in. Would be nice to have an option to "retain trailing spaces" Thanks, Dennis Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Monday, July 01, 2013 2:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SGET, Variables and Trailing <Space> Trailing spaces are routinely dropped by RBASE. This is the expected behavior. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Monday, July 01, 2013 4:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - SGET, Variables and Trailing <Space> All: RBGeX95(64) latest I'm attempting to SGET a three-character text string which includes leading and trailing <space>s: SET VAR vDot = (SGET(.vHumpty,3,5)) SHOW VAR vDot = '<sp><dot><sp>' is the intent. The capture length and starting position are correct. There is a trailing space in every target string. What I consistently get is: SET VAR vDot = (SGET(.vHumpty,3,5)) SHOW VAR vDot = '<sp><dot>'. I've attempted appending a <space> onto the end: SET VAR vTwoSpace = (.vDot + ' ') SHOW VAR vTwoSpace = '<sp><dot>' I've variablized the trailing space SET VAR v2ndSpace = ' ' SET VAR vTwoSpace = (.vDot + .v2ndSpace) SHOW VAR vTwoSpace = '<sp><dot>' What am I missing? Bruce
