Hi David, I recommend this but ONLY if all addresses have numbers followed by names. The results will be a bit off for addresses that are not a number followed by a name. For the field or column to hold the name of the street make a computed field in the table with the addresses that has this as the computation: (sget(address field,(slen(address field))-((sloc(address field,' '))),((sloc(address field,' '))+1))) For the field or column to hold the street number make a computed field in the same table with this as the computation: (sget(address field,(sloc(addrress field,' ')),1)) All you have to do is substitute the words "address field" in the two computational lines above with whatever name you gave your address column in the table you are working on. Regards, David Fitts ________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, September 28, 2010 9:56 AM To: RBASE-L Mailing List 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
