Yes.
Convert your existing coordinate column to text
Add two new columns to your table, East and North
Then use the left$ and right$ functions to extract the appropriate halves
of the 12 figure ref.
In the mapbasic window, the command would be something like "Update Table1
Set east = Left$(coordinate,6)", but it's quite easy to do this using the
TableUpdate dialog.
Yours
Martin Spiers
"Andrew Tracey"
<[EMAIL PROTECTED] To:
<MapInfo-L@lists.directionsmag.com>
mbc.gov.uk> cc:
Subject: MI-L
Coordinates
08/03/2005 09:51
Dear All
I have a MapInfo table, which has 1 column containing a 12-figure grid
reference. Is there any easy way to break this column in half to come up
with easting and nothings?
Andrew Tracey
Information Support Officer
Corporate Information
Corporate Development
South Tyneside Council
Westoe Road
South Shields
NE33 2RL
Tel: 0191 4247561
E-Mail : [EMAIL PROTECTED]
************************************************************************************************
************************************************************************************************
Please do not print this e-mail if you can help it - and help protect the
environment.
************************************************************************************************
This Message may contain confidential information and is protected by
copyright.
If you receive it in error please notify us and delete it without making
use of or copying it.
The addressee and other employees within the Council may read and copy any
e-mail
reply to this message and other e-mails you send to us.
Whilst we use virus checking procedures we accept no liability for viruses
and recipients
must rely on their own virus checking procedures.
************************************************************************************************
The Council's web site address is www.southtyneside.info
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15586
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15587
