Josh 37 Posted December 11, 2012 Report Share Posted December 11, 2012 So I have a list that has a bunch of duplicates in it. I am getting rid of the duplicates and outputing the list to a variable. But I would also like to output the duplicates to a variable so that one variable shows the list without duplicates and the other variable show the list of duplicates. I know how to remove the duplicates just not how to show which duplicates were removed. I have tried using the subtract lists parameter, but that doesn't seems to work. Any ideas? Example: Original list.... dentist Planodentist Planobest dentist Planodentist Dallasbest dentist Dallasgreatest dentist Planoleading dentist Planosupreme dentist Planosupreme dentist Planopremium dentist Planogreatest dentist Dallasleading dentist Dallassupreme dentist Dallas List with duplicates removed.... dentist Planobest dentist Planodentist Dallasbest dentist Dallasgreatest dentist Planoleading dentist Planosupreme dentist Planopremium dentist Planogreatest dentist Dallasleading dentist Dallassupreme dentist Dallas List of removed duplicates.... dentist Planosupreme dentist Plano Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted December 11, 2012 Report Share Posted December 11, 2012 add list to list, list from text, change text casing(%list, lower case) then loop though compare list if (contains(%list, text casing(list item to see if exists, lower case)))than remove list itemelsenothing save the list your looping through Quote Link to post Share on other sites
Josh 37 Posted December 11, 2012 Author Report Share Posted December 11, 2012 How does that Work if the list is already lowercase? Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.