Donald,
You can simply use the MID$() function.
If you have a column that has definition of Character 10 and you need to extract the
4th though 8th character then use the following command:
Update TableName Set ColumnName = MID$(ColumnName,3,5)
If you need to search for a string within a string then use the MID$() with the
InStr() function.
If you have a column that you want to extract a string from (in the example below the
string "World") use the following command:
Update TableName Set ColumnName =
MID$(ColumnName,InStr(1,ColumnName,"World"),5)
Hope this helps.
Tim Fast
Pioneer Hi-Bred International, Inc.
-----Original Message-----
From: Don Guerra [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 11:00 AM
To: MapINFO (MapINFO)
Subject: MI-L String Expression
Hi List,
I know how to concatenate two strings, but is there a way to remove a
substring?
I am attempting to do this via "Update Column".
TIA
Donald Guerra
Municipal Authority of Westmoreland County
P.O. Box 730
Greensburg, Pa 15601
724-834-6500 x182
This communication is for use by the intended recipient and contains
information that may be privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender
by return e-mail and delete this e-mail from your system. Unless
explicitly and conspicuously designated as "E-Contract Intended",
this e-mail does not constitute a contract offer, a contract amendment,
or an acceptance of a contract offer. This e-mail does not constitute
a consent to the use of sender's contact information for direct marketing
purposes or for transfers of data to third parties.
Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean
http://www.DuPont.com/corp/email_disclaimer.html
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9730
