Hi,
You might want to try using the table|update column with the following
command
update :tablename
column : new column name (or temporary)
from :same tablename
value :mid$(base column name,11,len(base_column_name))
The mid$ function is described under help/functions/sting functions.
Regards
Jason
Jason Martin
Water Resources
SMEC Australia
Phone: (02) 9925 5584
Date: Wed, 18 Oct 2000 11:07:13 +0200
From: =?iso-8859-1?Q?=22Grasnick=2C_Bj=F6rn=22?=
<[EMAIL PROTECTED]>
Subject: AW: MI-L Truncating a column
Hi,
maybe you should try to export two columns of that table, the column you
want to edit and a unique key column. Then you may edit in a spreadsheet
programm or word processor with find/replace (replacing "NBS S&I - " with an
empty string), save and reimport into MapBasic. Finally you use Table |
Update Column (-> "Add temporary column")to add the edited column, using the
key column as match criterium and save the *.TAB file.
I don't know if this is the most elegant way, but it should work.
Regards,
Bjoern
Bj�rn Grasnick
Geomarketing
Callino GmbH
Trimburgstrasse 2
D-81249 Muenchen
Fon: +49 (0)89 41075 918
Fax: +49 (0)89 41075 949
E-Mail: [EMAIL PROTECTED]
- -----Urspr�ngliche Nachricht-----
Von: Govind, Vinesh [mailto:[EMAIL PROTECTED]]
Gesendet am: Mittwoch, 18. Oktober 2000 10:46
An: '[EMAIL PROTECTED]'
Betreff: MI-L Truncating a column
Wichtigkeit: Hoch
Hi
I have a column in my table called "Branch_Name"
This column is populated with all branch names in them.
Before each of the branch names there is "NBS S&I - "
I would like to remove "NBS S&I - " before each record.
Can someone explain to me how do I go about doing this?
Thanks.
Kind regards.
Vinesh Govind
NBS - Marketing
(T) 364 2106
(F) 364 2915
Email: [EMAIL PROTECTED]
_______________________________________________________________________
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.
