Tony,
You can use a combination of the Left$,Right$,Len and InStr functions as
such:
1stPart=Left$(STREET,InStr(1, STREET, " "))
2ndPart=Right$(STREET,Len(STREET)-InStr(1,STREET," "))
Hope this helps,
Chris Perry
Manager Mapping Systems
Parks Victoria
Melbourne Australia
Ph: 613 9816 6800
Fax: 613 9816 7222
[EMAIL PROTECTED]
-----Original Message-----
From: Tony Kelava [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 13 January 1999 18:05
To: [EMAIL PROTECTED]
Subject: MI Splitting info from 1 column into 2
Hi All,
Can anyone tell me how I can split one column of info into 2 columns.
For example in column 1 I have the street name SMITH ST
I want to then create 2 columns, one with the SMITH part and the other
with the ST part. There is a space between each street label, can I
use this somehow?
Regards
Tony
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
