Tony,
I think you will need to create two new columns and then use the update
column functionality with the functions Left$, Right$, Len and Instr to
update them from the original column value. Something like:
Left$(original_column, Instr(1,original_column, " ") -1) (for the first
part)
and
Right$(original_column, Len (original_column) - Instr(1, original_column, "
")) (for the second)
Richard Burkmar.
Tony Kekva wrote:
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?
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
