Actually I must correct myself. That will not work because the unique value column (typically an autoincrementing integer) will not be unique for each record. Instead, assuming your lines of text are in a column called "textdata"
SELECT textdata UNIQUE FROM... Bob S > On Mar 14, 2022, at 08:29 , Bob Sneidar via use-livecode > <[email protected]> wrote: > > They depend on the fact that arrays cannot have duplicate keys. Dumping the > data into an SQL database and querying using the UNIQUE statement would do it > too. > > SELECT * UNIQUE from ... > > Bob S > > > >> On Mar 13, 2022, at 13:16 , Roger Guay via use-livecode >> <[email protected]> wrote: >> >> Thank you Jacqueline, Alex and Terry. Very interesting new (for me) methods >> that I would never have come up with on my own. >> >> Roger >> >>> On Mar 13, 2022, at 1:05 PM, J. Landman Gay via use-livecode >>> <[email protected]> wrote: >>> >>> On 3/12/22 8:54 PM, Roger Guay via use-livecode wrote: >>>> I have a field with about a thousand lines with many duplicate lines, and >>>> I want to delete the duplicates. Seems like this should be simple but I am >>>> running around in circles. Can anyone help me with this? >>> >>> Making the list into an array is the easiest way but as mentioned, it will >>> destroy the original order. If the order is important then you can restore >>> it with a custom sort function. Here's my test handlers: >>> >>> >>> on mouseUp >>> put fld 1 into tData -- we keep this as a reference to the original order >>> put tData into tTrimmedData -- this one will change >>> split tTrimmedData by cr as set -- removes duplicates >>> put keys(tTrimmedData) into tTrimmedData -- convert to a text list >>> sort tTrimmedData numeric by origOrder(each,tData) >>> put tTrimmedData into fld 1 >>> end mouseUp >>> >>> function origOrder pWord, @pData >>> set wholematches to true -- may not matter, depends on the data >>> return lineoffset(pWord, pData) >>> end origOrder >>> >>> Field 1 contains lines in random order with duplicates. >>> >>> -- >>> Jacqueline Landman Gay | [email protected] >>> HyperActive Software | http://www.hyperactivesw.com >>> >>> _______________________________________________ >>> use-livecode mailing list >>> [email protected] >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
