To install the TextFX in the latest release of Notepad++ you need to download it from here: Or subscribe directly on tinyletter.Notepad++ with the TextFX plugin can do this, provided you wanted to sort by line, and remove the duplicate lines at the same time. Subscribe to new posts? E-mail: Yes, subscribe me! 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
0 kommentar(er)
