yes, your right. messed up my example it's in a access table, that gets loaded into VirtualTree (Soft-gems.net) I was trying to do it within virtualTree, but it's getting me nowhere.
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Kevin McCoy Sent: Monday, June 29, 2009 4:53 PM To: [email protected] Subject: [delphi-en] Re: Is this possible? if so how Given your example list and rules shouldn't the resulting list look like this: Peter CA Jan CA Marge CA Donald CA What is the storage method of this data? I'd write something in SQL if your data is in a table somewhere. --- In delphi...@yahoogrou <mailto:delphi-en%40yahoogroups.com> ps.com, "Perry Kappetein" <pkappet...@...> wrote: > > Hi > > I am trying to figure this out, to see if it's possible at all > > I have a listtree/listview with the following > > 12 rows with 2 collumns > > > First column has names and the 2nd one has the State > > Donald WI > Peter CA > Jan OK > Marge NH > Donald CA > Peter DC > Jan CA > Marge CA > Donald FL > Peter FL > Jan FL > Marge FL > > I want to take out the duplicates But with the Rule that if they are in CA > they should show, and if there is no CA then take FL > > So it should end up like this > > > Peter CA > Jan CA > Marge CA > Donald FL > > I can't find much info regarding duplicates, > is there a way to do it like that? > > Thanks so much > > Perry > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]

