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"
