Another option might be to use 'combine objects using column' option in the table menu and select the column that needs duplicate attributes removing. This will retain the geography.
> -----Original Message----- > From: Simon Roy [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, December 12, 2002 5:01 PM > To: Mapinfo-L > Subject: SUM: MI-L Remove duplicates based on an attribute > > Question : How can I remove duplicates in a text layer based on the text > string only. > > Answer : Create a new column and update with objectinfo(obj,3). Use > skimall.mbx to remove all the duplicates in the new column created. > > Thanks to everybody! > > Simon Roy > Sp�cialiste en g�omatique > Carto-M�dia, Environnement Illimit� > Montr�al > t�l.:514-849-7281 > Fax.:514-849-6770 > Courriel : [EMAIL PROTECTED] > ----- Original Message ----- > From: "Jacques Paris" <[EMAIL PROTECTED]> > To: "Simon Roy" <[EMAIL PROTECTED]> > Sent: Thursday, December 12, 2002 11:05 AM > Subject: RE: MI-L Remove duplicates based on an attribute > > > > Skimall should have the possibility to select on column contents; if > your > > text is the string of the objects, you may have to convert them to a > tabular > > attribute (create a new column, string as wide as your largest text, > then > > update it with objectinfo(obj,3) ) then you can skim on that column. > > > > Jacques Paris > > -----Original Message----- > > From: Simon Roy [mailto:[EMAIL PROTECTED]] > > Sent: December 12, 2002 10:54 > > To: Mapinfo-L > > Subject: Re: MI-L Remove duplicates based on an attribute > > > > Jacques, > > > > Skim and Skimall remove identical objects wich is not my case. I'm > > working on a text layer. What I want is to remove duplicate texts based > > only on text string and not on anchor point and/or rotation angle. > > > > Thank you. > > > > Simon Roy > > GIS Specialist > > Carto-M�dia, Environnement Illimit� > > Montreal > > tel.:514-849-7281 > > Fax.:514-849-6770 > > Email : [EMAIL PROTECTED] > > ----- Original Message ----- > > From: "Jacques Paris" <[EMAIL PROTECTED]> > > To: "Simon Roy" <[EMAIL PROTECTED]> > > Sent: Thursday, December 12, 2002 10:29 AM > > Subject: RE: MI-L Remove duplicates based on an attribute > > > > > > > Have a look at skim and skimall in the PPCC section of > > www.paris-pc-gis.com. > > > A document Identity.doc is also in the zip of Skimall. > > > > > > Jacques Paris > > > -----Original Message----- > > > From: Simon Roy [mailto:[EMAIL PROTECTED]] > > > Sent: December 12, 2002 10:23 > > > To: Mapinfo-L > > > Subject: MI-L Remove duplicates based on an attribute > > > > > > Hi all, > > > > > > I want to remove duplicates based on an attribute. I tried to do > this > > > with a serie of queries using group by, but I can't keep the > geographic > > > objects attached to the result. Is there a quick way to do this? > > > > > > Thank you > > > > > > Simon Roy > > > GIS Specialist > > > Carto-M�dia, Environnement Illimit� > > > Montreal > > > tel.:514-849-7281 > > > Fax.:514-849-6770 > > > Email : [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > List hosting provided by Directions Magazine | www.directionsmag.com | > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > Message number: 4514 > > > > > > > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 4517 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4564
