Hi guys,

My first post. I am not big director user. Although I have been using it on and off for the last seven years. So I have a real love, hate relationship with the program.

Anyway my question. I am in the middle of producing a CD that is powered by an access DB. I am using Datagrip to pull the data from access. But I have a problem. I am returning one of the columns/fields as a list. But I need to remove any duplications from the list. How do i go about doing this???? I have had a search on here and can not seam to find anything.

Any ideas?

Thanks
Si



Edited 3 time(s). Last edit at 07/17/2006 08:08AM by sroberts.

Sorry forgot an example...


gInboundList =["blah", "blah", "blah", "blah1", "blah2", "blah3", "blah3", ]

I need to be able to process this and remove the duplicates. But really not sure on how to go about it or where to begin.

Thanks
Si

A simple way could be

on RemoveDoubles (aList)
  tempL = []
  repeat with i in aList
    if (getOne(tempL, i) = 0) then tempL.add(i)
  end repeat
  return tempL
end

Copying the list by looking if the element still exist, and if not, adding
it to the new one:

l = [1,1,2,3,4,5,6,7,1,1,7]
put RemoveDoubles(l)
-- [1, 2, 3, 4, 5, 6, 7]

hih
Aldus

-------------

-- Sorry, i knew: first test, then post. Sorry for the typos in the last one

on RemoveDuplicates (aList)
  newList = []
  repeat with i in aList
    if (getOne(newList, i) = 0) then newList.add(i)
  end repeat
  return newList
end

Regards
Aldus

-------------

Thank you! That worked a treat!

Si



Edited 1 time(s). Last edit at 07/17/2006 08:53AM by sroberts.