3 Messages
•
90 Points
Lists: Delete duplicate entries in personal list
Hi all!
I am asking for help related to my personal lists
Since the jurassic I used imdb watchlist as the list containing the titles I have seen, not the one I have to see.
The reason for that is that, at the beginning, personalized lists were missing (or at least I couldn't find them) and, when new lists were added, a functionality to completely compy lists was missing.
Now I see that this functionality have been implemented...and I used it.
What happened, unfortunately, is that a lot of title get duplicated and I could not find all of them, considering that, when editing, the alphabetical order is not provided.
So I am here to ask if you encountered the same problem and, if so, how did you solve it!
Thank you!
Christian
I am asking for help related to my personal lists
Since the jurassic I used imdb watchlist as the list containing the titles I have seen, not the one I have to see.
The reason for that is that, at the beginning, personalized lists were missing (or at least I couldn't find them) and, when new lists were added, a functionality to completely compy lists was missing.
Now I see that this functionality have been implemented...and I used it.
What happened, unfortunately, is that a lot of title get duplicated and I could not find all of them, considering that, when editing, the alphabetical order is not provided.
So I am here to ask if you encountered the same problem and, if so, how did you solve it!
Thank you!
Christian
claire
950 Messages
•
41.6K Points
8 years ago
Thanks for providing this feedback. Please know that at this time, the only sort options available in "Edit mode" for a list are List Order and Date Added. I'm sorry for any inconvenience this may cause
I've passed along this feedback to the appropriate team; we'll also change this post to an "Idea" where it can be reviewed by other IMDb staff and users for consideration for future updates.
Let us know if we can offer further help.
1
bderoes
Champion
•
5.1K Messages
•
118.7K Points
8 years ago
If it's the list is of moderate length and you don't care about keeping comments or order, sort it alphabetically using Advanced Title Search, compact mode to get something easier to scan. For instance:
http://www.imdb.com/search/title?lists=watchlist&view=simple&sort=alpha,asc&count=250
Once you spot the duplicate, go to its title page and (assuming you use standard view, not reference view), and unselect it from the target list, then re-add it to the list. (Unselecting from the title page deletes all occurrences within the list.)
On the other end of the spectrum, if it's a really long list and you need to preserve comments and/or order in the list, here's a method I documented a couple of months ago using Export:
In case someone is reading this who wants to find duplicates in their own long list, here's what I did in Open Office Spreadsheet; Excel will be the same with one possible exception noted below:
- sort the whole sheet by the title ID
- insert a new column before col A
- in cell A2, enter the formula =IF(OR(C2=C3;C2=C1);"*****";"")
- in Excel each ; might need to be ,
- I used the OR to see both dupes after step 8
- copy cell A2
- highlight all the cells in column A that have title data in their row (I do this by ctrl-End to the bottom of the list, highlight the last col A cell, hold shift while pushing the scroll bar up to the top, and clicking on the cell A3)
- paste the clipboard to all those highlighted cells (you could paste to the whole column, but I've had trouble with that in the past). //Rather than scrolling through the list, I want to bring the dupes to the top, so:
- highlight col A, copy col A, Paste Special (not just Paste) col A (text but not formulas)
- click on a cell in col A (very important!) to release the highlight, then sort Z to A
You should see your dupes at the top of the list.If you don't want to deal with formulas, just sorting the export in the spreadsheet by the Title, then visually scan for duplicates, and observe the Position number for the version you want to delete, and then find it in Edit mode.
6
0