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 > <use-livecode@lists.runrev.com> 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 | jac...@hyperactivesw.com > HyperActive Software | http://www.hyperactivesw.com > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
