Thank you, Adriana. An excellent suggestion. I did a quick check of the imported data to see which <space> character had been imported:
cls SELECT TOP 1 glRawString into vHumpty from tt_glImport set var vChar = (ICHAR((SGET(.vHumpty,1,5)))) show var vChar This returned ASCII 32. With this as the target value: vHumpty = '1234<sp>.<sp>BlahBlah' ... Intending to return '<sp>.<sp>' ... ... I plugged '32' into your structure: SET VAR v2ndSpace TEXT = (CHAR(32)) SET VAR vDot = ((SGET(.vHumpty,3,5))+.v2ndSpace) ... which returned: '<sp>.' So I tried: SET VAR vDot = ((SGET(.vHumpty,3,5))+(CHAR(32))) ... which returned: '<sp>.' *Sigh* Time for SRPLing with magic characters. Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Adriana Montano Sent: Monday, July 01, 2013 3:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SGET, Variables and Trailing <Space> Bruce, Will this help if you are appending the end space?: SET VAR v2ndSpace TEXT= (CHAR(160)) Adriana -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Monday, July 01, 2013 4:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SGET, Variables and Trailing <Space> That works. Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Monday, July 01, 2013 2: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
