serouche, If you know SQL you could write a stored procedure that would identify the duplicates and then update a separate field on the form (ie. Set an Optional Checkbox field to 0). Followed by a filter that would delete each of the records which have a value in this checkbox field.
If you need users to be able to run this at anytime trigger it from an Active Link. HTH Stephen Remedy Skilled Professional -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Monday, January 21, 2008 6:28 AM To: arslist@ARSLIST.ORG Subject: Re: how to remove duplicate entries Hi, You could create a table-field that sorts its content on the field(s) you want to remove duplicates from. Also include the request-id in one column. Table Field with Columns: - TblColValue - TblColReqID Create a display-only-temp-fields: - TempPrevValue Then you create Active Links for a table-loop-guide: AL 1: Run If: $TblColValue$ = $TempPrevValue$ Action Run Process: @@:Application-Delete-Entry "Form" "$TblColReqID$" AL 2: Run If: Action Set Fields: TempPrevValue = $TblColValue$ Create the Guide and add the above Active Links: Create an Active Link that calls the guide with Table Loop activated. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > dear all, > > I would like to clean-up duplicate entries in a character field. > I must use AL on the web. > How can I do this? > Through filters I would do something like "RUN PROCESS echo "MYFIELD" | > sort | uniq" and that will do but through AL on the web I don't see. > Please help. > Thank you. > > serouche > /"because there is always a remedy to help you"/ > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
