Order a list and remove duplicates

Quick links

You have a given list, and want to remove duplicates, quickly and easily ?

One of the possible solutions, free and effective, is to use Notepad++ [1], a free text editor, but, on top of it, it is light, and offers lot of interesting functionalities.

You will also have to install TextFX plugin. To do so, go on SourceForge [2], and download the latest plugin version (Fig 10). You then just have to extract downloaded archive in your Notepad++ installation folder (Fig 11).

Order a list and remove duplicates : Fig 10 : TextFX Plugin download on SourceForge
Fig 10 : TextFX Plugin download on SourceForge
Order a list and remove duplicates : Fig 11 : Plugin installation for Notepad++
Fig 11 : Plugin installation for Notepad++

Once Notepad++ is launched, you can have a file containing duplicates (Fig 1).

Order a list and remove duplicates : Fig 1 : Notepad++ file with duplicates
Fig 1 : Notepad++ file with duplicates

In order to delete them, in a first time, verify that the option “+Sort outputs only UNIQUE (at column) lines” (Fig 2) is set, and then select your data (Fig 3).

Order a list and remove duplicates : Fig 2 : Notepad++ sort unique
Fig 2 : Notepad++ sort unique
Order a list and remove duplicates : Fig 3 : Notepad++ select data
Fig 3 : Notepad++ select data

You now got two choices :

- delete duplicates in case insensitive mode (Fig 4), as result you will get lines containing same letters as other lines deleted (Fig 5),

- delete duplicates in case sensitive mode (Fig 6), as result you will get lines identical to other ones deleted (Fig 7).

Order a list and remove duplicates : Fig 4 : Notepad++ sort case insensitive
Fig 4 : Notepad++ sort case insensitive
Order a list and remove duplicates : Fig 5 : Notepad++ duplicate lines removed
Fig 5 : Notepad++ duplicate lines removed
Order a list and remove duplicates : Fig 6 : Notepad++ sort case sensitive
Fig 6 : Notepad++ sort case sensitive
Order a list and remove duplicates : Fig 7 : Notepad++ identical lines removed
Fig 7 : Notepad++ identical lines removed

You can then, with the two newly created list, after having them copied in different files, compare them (Fig 8), with, as result, the display in first file of lines that do not exist in the second one, and, in the second one, the display of lines that do not exist in the first file (Fig 9).

Order a list and remove duplicates : Fig 8 : SENotepad++ compare files
Fig 8 : SENotepad++ compare files
Order a list and remove duplicates : Fig 9 : Notepad++ compare results
Fig 9 : Notepad++ compare results

Similar articles

Comments (12)

Levi Hines, 2018-08-19
Great, that is exactly what I was looking for, now I’m ready
Deborah Morris, 2018-08-19
Merci c'était utile
Julie Sanders, 2018-08-19
Uimitor, acum este rândul meu să încerc!
Susan King, 2018-08-19
Não posso acreditar que finalmente encontrei a solução, isso foi um pesadelo por um longo tempo, agora resolvido
Fallencene, 2018-08-19
素晴らしい情報、共有のおかげで
AraGiga, 2018-08-19
Das hat gut für mich funktioniert, ich brauche nicht weiter zu suchen
Markedwa, 2018-08-19
हैलो, मैंने आपका लेख देखा और इससे मुझे मेरी समस्या हल करने में मदद मिली, बहुत बहुत धन्यवाद
lanewshit3, 2018-08-19
مرحبًا ، لقد رأيت مقالك وساعدني في حل مشكلتي ، شكرًا جزيلاً
Pisphincinickr, 2018-08-19
Dobrý den, viděl jsem váš článek a pomohl mi vyřešit problém, díky moc
francannak, 2018-08-19
Täpselt, mida ma otsisin, täiuslik
Sood, 2018-11-05
Vos images sont en 404
ybierling, 2018-11-05
Merci pour votre retour, le problème devrait à présent être résolu

Leave a comment