Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How Can I sort a text file by line length in notepad++? Is there any plugin available for the mentioned task?
In case that there is no plugin, What is the first and maybe second tutorial to read, In order to write the plugin Myself?

share|improve this question
1  
You know, sometimes it's best to just write some code and get it over with. –  Daniel R Hicks Sep 16 '13 at 15:14
    
Are you dealing with small or large files? –  ComFreek Sep 19 '13 at 19:58
    
50 MB file with long lines, about 250 KB length. –  HPM Sep 20 '13 at 11:35
    
Is the data sensitive? Or could you share it on Dropbox/Google-Drive/etc.? If Notepad++ can open and handle that file, I would imagine that my solution would work, but I'd love to try it out myself. –  Dane Sep 20 '13 at 15:18
    
Hey @HPM, any chance of getting to work on your data? –  Dane Sep 24 '13 at 20:17

4 Answers 4

No I don't think there is. The closest is TextFx plugin but that's an character based sort not line length based. Your best bet is to throw the text into a spreadsheet and sort it there (using a separate computed column using the LEN() function).

share|improve this answer
    
Thanks, the text file has long lines and huge total size, so I put spreadsheet editors away. Let Me Update the Question. –  HPM Jun 18 '13 at 16:58
    
@HPM well if you're willing to look outside notepad++ then command line would do it. like use some commands to get the length of the line each the end of each line. then you'd at least be nearer to doing it. –  barlop Sep 16 '13 at 15:34
    
thanks, it's a good advice. What I am curious about is NP++ many plugins, why this one doesn't exist? –  HPM Sep 17 '13 at 9:52

You can use SQL in N++ in CSV files ! For example if you have :

col1;
hgfhfghfhg;
khjfhgfhfghfgh;
kjhfhgfhfhgfghfhf;
lkjgjghjhg;
lkjgjg;

, you can execute command select * from data order by length(col1) desc to sort descending. "data" means current file. "col1" - name of first (and last) column.

Unfortunately there is probably bug that doesn't allow abandon delimiter after lines in one-column text.

share|improve this answer
    
This is actually a great solution, if only SQL in N++ didn't mangle the data output. I just tested out your solution, and I added delimiters to the end of all lines with a quick regex replace, but the data output converts everything to lowercase, and replaced my dashes with question marks. –  Dane Sep 16 '13 at 13:56
    
@Dane (I don't currently have access to Notepad++.) Perhaps try adding a single quote to the beginning and end of every line (and then the semicolon after that)? Maybe double quotes? –  Bob Sep 16 '13 at 14:39
    
@Bob: no good. The lowercase thing is even mentioned in the release notes for the SQL in N++ plug-in. –  Dane Sep 16 '13 at 15:10

This answer is inspired by a YouTube video. Updated to maintain original sort order, if that is important.

Notepad++ has a built-in TextFX tool that sorts selected lines alphabetically. This tool can be hijacked to sort by the length of the lines by placing spaces on the left of each line, and making sure that all the lines are the same length.

"The Zoo" comes alphabetically before "Their House" because the space is treated as a character and comes before "i". __X (pretending the underscores are really spaces) will similarly come alphabetically before _XX. The idea in this answer is to add spaces and line numbers so that __________092dog will be sorted above _003alligator.

I'll use the following as example data:

Lorem
ipsum
dolor
sit
amet
consectetur
adipisicing

Step 1. Add line numbers.

(Note added by barlop- a note for the reader regarding this step, we will not be sorting according to these line numbers, we're sorting according to the length of the lines. But the reason for adding the line numbers, is so we know the natural order, so that when for example, two+ lines are of equal length we can sort those lines according to that natural order)

Assuming your text file only has the data in it, place the text cursor (the vertical line) into the very first position of the file. Then in the Edit menu select Column Editor... (Alt+C). Choose "Number to Insert" and start with 1, increase by 1, and include leading zeros. Note that this will retain the original ordering when sorting from shortest string to longest string. Reverse all lines first if you want to sort longest to shortest.

1Lorem
2ipsum
3dolor
4sit
5amet
6consectetur
7adipisicing

Step 2. Pad all lines with leading spaces.

Place the text cursor (the vertical line) into the very first position of the file. Then in the Edit menu select Column Editor... (Alt+C). Insert enough spaces so that the shortest line of data will be padded out to the length of the longest line of data. If your shortest line has 4 characters, and your longest 44, then make sure you insert at least 40 spaces.

__________1Lorem
__________2ipsum
__________3dolor
__________4sit
__________5amet
__________6consectetur
__________7adipisicing

Step 3. Trim lines to a uniform length.

Use the following Regular Expression Find/Replace (Ctrl+H) to match the right-hand characters equalling or exceeding the length of your longest data line.

^.*(.{50})$

Replace all with $1. That will trim everything except the right-most 50 characters of every line. If your data is longer (or short) than 50, adjust the {50} in the Regular Expression.

(Note added by barlop- the idea here is the shortest lines have the most spaces at the beginning)

_______1Lorem
_______2ipsum
_______3dolor
_________4sit
________5amet
_6consectetur
_7adipisicing

Step 4. Sort the lines.

Select all of the text (Ctrl+A). Via the TextFX menu, go to Text FX > TextFX Tools > Sort lines case sensitive (at column). Your data should now be in length order, from shortest to longest. If you want them in order from longest to shortest, uncheck the Text FX > TextFX Tools > + Sort ascending option before sorting. Note how line numbers are reversed as well.

_________4sit
________5amet
_______1Lorem
_______2ipsum
_______3dolor
_6consectetur
_7adipisicing

Step 5. Remove leading spaces.

Use another Regular Expression Find/Replace (Ctrl+H) to match the leading spaces.

^ *\d{4}

That's a space between the caret and asterisk. Replace all with nothing. That will remove all leading spaces and the inserted line numbers, if you had 4-digit line numbers. Replace the {4} with the correct number of digits in your line numbers.

sit
amet
Lorem
ipsum
dolor
consectetur
adipisicing

MACRO

I recorded the above steps using Notepad++'s macro feature, and it doesn't work. I'm not sure which step fails, but I haven't diagnosed why. You could probably use AutoHotKey to automate this if you do it repeatedly.

share|improve this answer
1  
Warning: this is not a stable sort. In other words, lines of the same length will not necessarily appear in the same order after sorting - instead, they will be sorted lexicographically. –  Bob Sep 16 '13 at 14:37
    
@Bob is correct, if you have lines of a given length, such as 33 characters, that have a particular order to them, that will not be reflected in the results. We can add the line numbers with Alt+C prior to step 1 (including leading 0s to ensure that lengths remain equal). Then, when cleaning up in step 4, use ^ *\d{5} or whatever number of digits were used for the line numbers. –  Dane Sep 16 '13 at 15:12
1  
The answer has been updated to retain the existing sort order, assuming that is important. –  Dane Sep 16 '13 at 15:25
    
nice one dane for following what that guy in the youtube video was doing, where he also disabled comments. Can you include a link to text where you think it fails, on pastebin pastebin.com ? and did it fail only with the macro, or manually also? –  barlop Sep 18 '13 at 14:33
    
@barlop I'll see if I can do a little diagnosis on the N++ macro. The result from my simple attempt was terribly corrupted results with many unusual and non-printing characters added. Also, while I was inspired by the YouTube video, my steps are a bit different. –  Dane Sep 18 '13 at 14:44

Or if you happen to have linux and nedit:

ctrl-a
alt-r
perl -e 'print sort { length($a) <=> length($b) } <>'
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.