She loves data and coding, as well as teaching and sharing knowledge - oh, and sci-fi, coffee, chocolate, and cats 🤓 Series

Once you find it, however, it can save you a lot of time 🤓Ĭathrine Wilhelmsen is a Microsoft Data Platform MVP, BimlHero Certified Expert, international speaker, author, blogger, organizer, and chronic volunteer.

That’s it! This is a very handy feature, but it is somewhat hidden away in the menu. Then, use the Sort lines case sensitive feature. In the 32-bit version of Notepad++, you can use the TextFX plugin to quickly remove duplicates, remove blank lines, and sort data - in one operation! First, make sure that you have the Sort outputs only UNIQUE option enabled. In this example, we ended up with only 15 lines: Tadaaa! 🥳 We have now removed duplicates and blank lines, and the data has been sorted alphabetically. Select all the text, click TextFX → TextFX Tools → Sort lines case sensitive (at column) or Sort lines case insensitive (at column):Ĥ. In this example, we have 500 lines, and half of them are blank:ģ. In the Notepad++ window, paste the text that you want to remove duplicates and blank lines from. Click TextFX → TextFX Tools → Enable Sort outputs only UNIQUE (at column) lines:Ģ. We want to find all the unique data types used, and also sort them alphabetically.ġ. In this example, we have a list of data types used in a SQL Server table. Remove Duplicates, Remove Blank Lines, and Sort Data in One Operation Install the TextFX plugin ( this is not available in the 64-bit version of Notepad++).Install the 32-bit version of Notepad++.And as with any kind of automation: the more data you work with, the more time you save 🤓 You can use the 32-bit version of Notepad++ with the TextFX plugin to quickly remove duplicates, remove blank lines, and sort data - in one operation! This is a fast and easy way to get the results you want in just a few seconds.

Notepad++ plugins sort lines