Hi Carolyn,
There's surely a way to do this using the / as a separator, but in my
limited ways I use the Left$() function. Trick is you have to have the same
number of places each time, so if your numbers grow you'll have to do it
multiple times on fixed width subsets.
You can update your other column with a fixed portion of that first
reference using
Update column, set 'blank field' = Left$('reference field',1) that gets the
first character from the left...or use ,2 or ,3 and so on to get the first 2
or 3 characters from the left.
To help get subsets you can select using the character length of the field
entries such as Len('reference field')=5 for example...
Will Mitchell
Mitchell Geographics, Inc.
496 Congress Street
Portland, Maine 04101
207.879.7769
www.mitchellgeo.com
-----Original Message-----
From: Carolyn Bergin [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 8:31 PM
To: [EMAIL PROTECTED]
Subject: MI-L SQL Help
Hi guys
I have a dataset that contains a field with references like 1/375 and
2/540 etc. I need to update another column with the just number
preceeding the /. Is there any way I can do this using an SQL. The
dataset is huge and im trying to save some time rather than going
through and manually updating them all.
Thanks in advance
Carolyn
Carolyn Bergin
GIS Officer
Planning and Strategy
email - [EMAIL PROTECTED]
phone - 9976 1593
fax - 9976 1400
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9473
