R>set var test text = 'abcd efg h'
R>set var pos1 int = (sloc(.test,' '))
R>show var pos1
          5

 R>set var test = (sget(.test,(.pos1-1),1))
R>show var test
abcd

Bernie Lis

----- Original Message ----- 
  From: Jim Belisle 
  To: RBASE-L Mailing List 
  Sent: Monday, May 16, 2011 7:24 PM
  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

   

Reply via email to