Thanks Javier, that is what I needed.
James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Monday, May 16, 2011 6:44 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FUNCTION Jim, You can use: SET VAR vFirstTextBlock = (SSUB(.vYourVariableWithBlanks,-1)) The -1 will select the first block using "blanks" as separator; using a positive number uses the current separator, normally a comma as separator, Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected] <mailto:[email protected]> ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, May 16, 2011 6:24 PM To: RBASE-L Mailing List Subject: [RBASE-L] - FUNCTION What function or combination of functions would I use to get rid of all text after a space in a row? I have rows in which I want to pull only the beginning text then get rid of everything after the space that follows this text. I know I can get the information with the SGET function but since the text at the beginning of each row is various lengths, I will end up with information I do not need. There will always be a space following the beginning text. James Belisle
