Hi Sabin! As you have noticed, the text visible on the map is not stored in the attribute table, but is a property of the geographic object. (as is font, style, color and so on).
But for many purposes, it is often adviseable to store the text string in the table as well. (But remember, these two know nothing of each other afterwards) Add a new field to the table, I called mine Extracted_text. Then use update column, or the MapBasic window to perform an update of the new column, using ObjectInfo(obj,3) as expression. Update text_tab Set Extracted_text = ObjectInfo(obj,3) This will extract the text string from each object and store it in your new column. For removing duplicates, I have no straightforward method or code, but if it is as you suppose, that the table has been appended to itself and not been edited or resorted since then, you should be able to see halfway down where the duplicates begin. HTH and Best regards Mats.E ________________________ FB Engineering AB S�dra F�rstadsgatan 26 211 43 Malm� Tel: 040-665 64 80 Mobil: 0705-27 60 27 Fax: 040-665 69 90 e-post: [EMAIL PROTECTED] http://www.fbe.se Sabin Mark <[EMAIL PROTECTED]> 2004-04-05 12:02 Till [EMAIL PROTECTED] Kopia �rende MI-L Duplicated text in a table Hi I have a large table with duplicated text (it looks as though a recent version of the table has been appended to an old one). I do not have the source data so cannot simply change the data to the latest version. Does anyone have a quick fix for locating duplicated strings of text from the map (as the text is not included in the attributes for the record) deleting the duplication, therefore leaving a single text string at that location? TIA ********************************************************************** Content: The views expressed in this email are personal and may not necessarily reflect those of South Derbyshire District Council, unless explicitly stated otherwise. Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. ********************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11271 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11272
