This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Dear Users
I have a column in my MapInfo table that has a street number and a street
name in one column.
I would like to separate them into two separate columns i.e. one column for
street number and another column for street name.
I have tried various syntax methods but find myself clueless in finding a
solution.
The problem I have is that street numbers vary in my table:
eg. 77 Gipsy Lane
144-146 Glenfield Road
77A Groby Road
So if I did truncate my column I still end up with text included from the
'shorter' address fields.
Any solutions or suggestions would be most welcome.
Regards.
Vinny
Vinesh Govind
Data Technician
Leicestershire County Council
Room 500 Area J5
* 0116 265 7257
_______________________________________________________________________
The contents of this message do not necessarily represent the
opinions, views, policy or procedures of Leicestershire County Council.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
