SET VAR vfull TEXT = '106 Main'
SET VAR vno TEXT = (CTXT( (INT( (SSUB(.vfull,-1)) ))))
SET VAR vstr TEXT = (trim((SGET(.vfull,((SLEN(.vfull))-(SLEN(.vno)))
,((SLEN(.vno))+ 1) ))))
sho var
vfull = 106 Main TEXT
vNo = 106 TEXT
vStr = Main TEXT
RETURN
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, September 28, 2010 9:55 AM
Subject: [RBASE-L] - SPLITTING AN ADDRESS
I AM USING RBASE FOR WINDOWS 7.1 AND NEED TO TAKE AN ADDRESS COLUMN AND FILL
TWO ADDITIONAL COLUMNS ONE COLUMN WITH ONLY THE STREET NUMBER (106) AND ONE
COLUMN WITH THE STREET (MAIN). IS THIS POSSIBLE???
THANK YOU,
DAVID
