Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!usc!isi.edu!gremlin!nrtc.nrtc.northrop.com!maurit From: maurit@nrtc.nrtc.northrop.com (Mark Aurit ) Newsgroups: comp.databases Subject: CLIPPER array dups problem Message-ID: <22963@gremlin.nrtc.northrop.com> Date: 24 Apr 91 20:17:21 GMT Sender: news@gremlin.nrtc.northrop.com Reply-To: maurit@nrtc.nrtc.northrop.com (Mark Aurit ) Distribution: usa Organization: Northrop Research & Technology Center, Palos Verdes, CA Lines: 21 In a program I take the contents of an ascii file, read it into a .dbf and manipulate it, then present it to the user with achoice(). Unfortunately, the ascii file contains dups, and I dont want my picklist to have any. What is the best way to remove them? Where is the best place - in the .dbf or in the array. Ascan() and adel() dont seem to do the trick. I guess I could try a locate/continue; Im wondering if anyone has a slick (but maintainable!) idea. On input, the ascii file might look like: 4 buffed.dbf trick.dbf stormin.dbf norman.dbf I APPEND it into a database, delete the first line, pack the file, read it into an array, then achoice() it. Thanks in advance Mark Aurit maurit@nrtc.northrop.com