Kent, I suppose you can do it in Mapbasic, but why not use a proper editing tool such as Access or Excel? If your table has unique identifiers, as most of them do, then you can export your table to a file such as delimited text or .dbf and import it into the software of your choice. There you can use 'search and replace' to easily edit your table. Then you can link to that table in MI with an SQL query using the common key. Exporting the resultant query will give you a consolidated table which you can then reimport and modify using 'table maintenance' to get rid of the spurious columns. Might be easier than trying to write complicated SQL or Mapbasic.
Good luck Robert Davis GIS Officer Alpine Shire Council Great Alpine Road P.O. Box 139 Bright Victoria 3741 Ph (03) 5755 0552 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 16 September 2005 6:47 AM To: [email protected] Subject: MI-L Extracting a character string after the last space I am standardizing a list of city names from numerous abbreviations. I am stuck on how to update part of the city name if it occurs at the end. For instance, HTS is an abbreviation for Heights. I can successfully update Vadnais Hts, and Mendota Hts, but not Oak Park Hts as it begins the replacement after the first space, not the second, or perhaps even third. Thank you. ____________ Kent Treichel Analyst-GIS Tax Research Minnesota Department of Revenue MS 2230 600 North Robert St St. Paul, MN 55146-2230 651-556-6150 ##################################################################################### Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. This message and any attachments have been scanned by MailMarshal. ##################################################################################### --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17893
