Sort lines of a txt file by lenght of the string

[Contro]

If each line is a string of text I would like to order the txt file from the short to the longest one.

How can I do this ?

[Ath]

insert the length, fixed format (0001 etc.), of each line in front of each line, with a separator
sort the file
remove the added columns, cut at the separator

[Ath]

Again a 'one-liner' this time using awk and sort:

[Select]

awk '{ printf"%04d|%s\n",length($0),$0}' contro.txt|sort|awk -F'|' '{print $2}'

- first awk command adds the length and the separator, a vertical pipe
- sort command puts them in the desired order
- second awk command removes the length and the separator
to redirect to a file, add this at the end:

[Select]

>length-sorted.txt

I've used Cygwin, then you might want/need to issue 'export LC_ALL=C' before running the command, else awk might give some error about binary data (the accented characters)
Couldn't find a way to do this in NotePad++ yet, maybe using the Python Script plugin for NotePad++, I'll investigate that later

I used your previous sample input text 'contro.txt' as input

[MrZebulon]

Give TED Notepad a try:

http://jsimlo.sk/notepad/


Best plain text editor ever ;-)

[Ath]

Give TED Notepad a try:

http://jsimlo.sk/notepad/

-MrZebulon (February 18, 2017, 12:21 PM)

Great tip!

Best plain text editor ever ;-)

-MrZebulon (February 18, 2017, 12:21 PM)

We'll see about that...

Now let's try this TED Notepad...

- Open the file
- Select All (Ctrl-A)
- Select Tools/Lines/Columns, Numbers... (Alt-T,L,N or Alt-Ctrl-Y)
- Change Output mask to (Line length right aligned with zeros, separator |, original line)

[Select]

%+l0|%0

- Press Cut (Alt-C), length and a separator are inserted in each line
- Select All (Ctrl-A)
- Sort Ascending (Tools/Sort/Ascending, Alt-T,S,A or Alt-Ctrl-A)
- Select All (Ctrl-A)
- Select Tools/Lines/Columns, Numbers... (Alt-T,L,N or Alt-Ctrl-Y)
- Change Output mask to

[Select]

%1

- Change settings on %1 tab
  - Select 'Entire line'
  - Check: 'Use only characters from
  - set: 'position' to 5
  - set: 'to' to 999 (assuming no line is longer than 999 characters, or use 9999)
(Have Preview checked, then the preview should show the result without length and separator, if a column is missing change 5 to 4 or 3)
- Press Cut (Alt-C)
- Save result (Ctrl-S or Ctrl-B, Save as...)
- Job well done

NB: The use of a separator is entirely optional, ofcourse

I kinda like this TED Notepad, looks like something safe enough for @Contro to handle

[Contro]

Give TED Notepad a try:

http://jsimlo.sk/notepad/

-MrZebulon (February 18, 2017, 12:21 PM)

Great tip!

Best plain text editor ever ;-)

-MrZebulon (February 18, 2017, 12:21 PM)

We'll see about that...

Now let's try this TED Notepad...

- Open the file
- Select All (Ctrl-A)
- Select Tools/Lines/Columns, Numbers... (Alt-T,L,N or Alt-Ctrl-Y)
- Change Output mask to (Line length right aligned with zeros, separator |, original line)

[Select]

%+l0|%0

- Press Cut (Alt-C), length and a separator are inserted in each line
- Select All (Ctrl-A)
- Sort Ascending (Tools/Sort/Ascending, Alt-T,S,A or Alt-Ctrl-A)
- Select All (Ctrl-A)
- Select Tools/Lines/Columns, Numbers... (Alt-T,L,N or Alt-Ctrl-Y)
- Change Output mask to

[Select]

%1

- Change settings on %1 tab
  - Select 'Entire line'
  - Check: 'Use only characters from
  - set: 'position' to 5
  - set: 'to' to 999 (assuming no line is longer than 999 characters, or use 9999)
(Have Preview checked, then the preview should show the result without length and separator, if a column is missing change 5 to 4 or 3)
- Press Cut (Alt-C)
- Save result (Ctrl-S or Ctrl-B, Save as...)
- Job well done

NB: The use of a separator is entirely optional, ofcourse

I kinda like this TED Notepad, looks like something safe enough for @Contro to handle

-Ath (February 18, 2017, 02:23 PM)

We are entushiastic of software !!!!!!
another notepad : pspad, notepad++, ted notepad .....

Running to try
First downloading the editor

[Contro]

I have tried. But I think i am doing something wrong.
Simple don't get results .

And try to apply all the steps !!!
 

[Ath]

Simple don't get results .

-Contro (February 19, 2017, 05:27 AM)

Huh? You do select all text (Ctrl-A) before running any of the tools? It makes working with the preview of "Tools/Lines/Columns, Numbers" possible, so you should see a preview while entering the Output mask.

You can attach a sample file here, or PM me for my e-mail, and I'll verify if the file is causing the trouble. Current TED Notepad seems to have issues with UTF-8 files without a BOM, and you might have such a file, but you should be able to use File/Re-open as UTF-8 and it could resolve your issue.

[Ath]

I have tried. But I think i am doing something wrong.

-Contro (February 19, 2017, 05:27 AM)

Uhm, did you retype the Output mask values, or copy/paste from this page?
Copy/paste is the least error-prone, especially as the first sequence is: percent, plus, lowercase-L, zero, vertical bar, percent, zero

[Ath]

Though it worked fine for me, using TED Notepad, I wanted to resolve this one using Notepad++ too.
It won't be possible to use the, quite limited, macro feature of Npp, so I used a scripting plugin: Notepad++ Python Script

[One time only]
- Install the Notepad++ Python Script plugin, using the MSI installer, not using the plugin manager. It can be downloaded from here. Close Notepad++ before the installer is run.
- Open Notepad++
- Check if Python Script is working correctly by opening the console: Plugins/Python Script/Show Console, en verifying that it shows the Python version, something like this:

[Select]

Python 2.7.6-notepad++ r2 (default, Apr 21 2014, 19:26:54) [MSC v.1600 32 bit (Intel)]
Initialisation took 125ms
Ready.

- Choose Plugins/Python Script/New Script, type a filename: sort-by-length.py, and press Save. The file is created and opened in Notepad++
- Paste this script into sort-by-length.py:

Code: Python [Select]

1. # Ath: Found this in the notepad-plus forum on sourceforge.net, modified as suggested in the comments there
2. editor.beginUndoAction()
3. if editor.getSelText(): # grab the lines
4.     linee = editor.getSelText().splitlines()
5. else:
6.     linee = editor.getText().splitlines()
7. sorted_lines=sorted(linee,key=lambda x:len(x)) # add parameter reverse=True, to sort descending by length
8. editor.clearAll() # wipe lines in editor
9. for line in sorted_lines:
10.     print(line) # put all lines back in the editor
11. editor.endUndoAction()

- Make sure the code is not indented (so each line starting on column 1) except for lines 4, 6 and 10 as they must be indented.
- Save the file
- The script should now be available in the menu Plugins/Python Script/Scripts/ (don't select it, it will execute immediately!)

[Process a file]
- Open the file to sort, and make sure it is the selected file
- Select Plugins/Python Script/Scripts/sort-by-length
- The file will be emptied and filled with all lines again, shortest first (or longest first if reversed=True was set). It may take some time, as Python (Script) doesn't seem very fast in this configuration
- If an error occurs during processing, it will be shown in the Python Script console (see above how to open that)
- Save the file
Done

Edit: Added sentence about the code needing to be at column 1

[anandcoral]

Hi Contro

You can try http://www.miniwebto...sort-text-by-length/

I got below result,

Sort lines of a txt file by lenght of the string

Regards,

Anand

[Lintalist]

For reference: short AutoHotkey example (one of several you can find there on the forum) https://autohotkey.c...ine-length/?p=149560

[Contro]

Simple don't get results .

-Contro (February 19, 2017, 05:27 AM)

Huh? You do select all text (Ctrl-A) before running any of the tools? It makes working with the preview of "Tools/Lines/Columns, Numbers" possible, so you should see a preview while entering the Output mask.

You can attach a sample file here, or PM me for my e-mail, and I'll verify if the file is causing the trouble. Current TED Notepad seems to have issues with UTF-8 files without a BOM, and you might have such a file, but you should be able to use File/Re-open as UTF-8 and it could resolve your issue.

-Ath (February 19, 2017, 06:43 AM)

I am going to try.
I was making by hand , not copy / paste.
I will put screenshots .

Trying !

[Contro]

Though it worked fine for me, using TED Notepad, I wanted to resolve this one using Notepad++ too.
It won't be possible to use the, quite limited, macro feature of Npp, so I used a scripting plugin: Notepad++ Python Script

[One time only]
- Install the Notepad++ Python Script plugin, using the MSI installer, not using the plugin manager. It can be downloaded from here. Close Notepad++ before the installer is run.
- Open Notepad++
- Check if Python Script is working correctly by opening the console: Plugins/Python Script/Show Console, en verifying that it shows the Python version, something like this:
[Select]

Python 2.7.6-notepad++ r2 (default, Apr 21 2014, 19:26:54) [MSC v.1600 32 bit (Intel)]
Initialisation took 125ms
Ready.

- Choose Plugins/Python Script/New Script, type a filename: sort-by-length.py, and press Save. The file is created and opened in Notepad++
- Paste this script into sort-by-length.py:
Code: Python [Select]

    # Ath: Found this in the notepad-plus forum on sourceforge.net, modified as suggested in the comments there
    editor.beginUndoAction()
    if editor.getSelText(): # grab the lines
        linee = editor.getSelText().splitlines()
    else:
        linee = editor.getText().splitlines()
    sorted_lines=sorted(linee,key=lambda x:len(x)) # add parameter reverse=True, to sort descending by length
    editor.clearAll() # wipe lines in editor
    for line in sorted_lines:
            print(line) # put all lines back in the editor
    editor.endUndoAction()

- Save the file
- The script should now be available in the menu Plugins/Python Script/Scripts/ (don't select it, it will execute immediately!)

[Process a file]
- Open the file to sort, and make sure it is the selected file
- Select Plugins/Python Script/Scripts/sort-by-length
- The file will be emptied and filled with all lines again, shortest first (or longest first if reversed=True was set). It may take some time, as Python (Script) doesn't seem very fast in this configuration
- If an error occurs during processing, it will be shown in the Python Script console (see above how to open that)
- Save the file
Done

-Ath (February 19, 2017, 06:51 AM)

I will try too.

The other method with notepad ted give me no results.

The zeros stay in the final result ?

[Contro]

Sort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the string

[Contro]

Hi Contro

You can try http://www.miniwebto...sort-text-by-length/

I got below result,

[ Invalid Attachment ]

Regards,

Anand

-anandcoral (February 19, 2017, 11:37 AM)

This method works fine.

[Contro]

For reference: short AutoHotkey example (one of several you can find there on the forum) https://autohotkey.c...ine-length/?p=149560

-Lintalist (February 19, 2017, 01:47 PM)

Trying

[Contro]

For reference: short AutoHotkey example (one of several you can find there on the forum) https://autohotkey.c...ine-length/?p=149560

-Lintalist (February 19, 2017, 01:47 PM)

Where have I to put the name of my txt file in the script ?

[Ath]

If you apply the description of my TED Notepad procedure, copy/pasting the 'Output mask' values from here, you should be fine, I think I see at least 3 typos in your first screenshot, and then it only gets worse from there...

[Contro]

I am doing bad. I obtain an error with the python script.

The screenshots :

Sort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the stringSort lines of a txt file by lenght of the string

[Contro]

If you apply the description of my TED Notepad procedure, copy/pasting the 'Output mask' values from here, you should be fine, I think I see at least 3 typos in your first screenshot, and then it only gets worse from there...

-Ath (February 19, 2017, 02:36 PM)

Don't worry I keep trying.

But it's strange for me. I think i am doing well.
Any option left ?

[Lintalist]

Where have I to put the name of my txt file in the script ?

-Contro (February 19, 2017, 02:18 PM)

The first line says

Code: Autohotkey [Select]

1. FileRead, text, %A_ScriptFullPath%

replace it with

Code: Autohotkey [Select]

1. FileRead, text, pathtoyour\file.txt

Assuming you want to save it replace MsgBox %text% with

Code: Autohotkey [Select]

1. FileDelete, pathtoyour\sortedfile.txt
2. FileAppend, %text%, pathtoyour\sortedfile.txt

[Contro]

Where have I to put the name of my txt file in the script ?

-Contro (February 19, 2017, 02:18 PM)

The first line says

Code: Autohotkey [Select]

1. FileRead, text, %A_ScriptFullPath%

replace it with

Code: Autohotkey [Select]

1. FileRead, text, pathtoyour\file.txt

Assuming you want to save it replace MsgBox %text% with

Code: Autohotkey [Select]

1. FileDelete, pathtoyour\sortedfile.txt
2. FileAppend, %text%, pathtoyour\sortedfile.txt

-Lintalist (February 19, 2017, 02:58 PM)

Trying. Best Regards

[Contro]

Where have I to put the name of my txt file in the script ?

-Contro (February 19, 2017, 02:18 PM)

The first line says

Code: Autohotkey [Select]

1. FileRead, text, %A_ScriptFullPath%

replace it with

Code: Autohotkey [Select]

1. FileRead, text, pathtoyour\file.txt

Assuming you want to save it replace MsgBox %text% with

Code: Autohotkey [Select]

1. FileDelete, pathtoyour\sortedfile.txt
2. FileAppend, %text%, pathtoyour\sortedfile.txt

-Lintalist (February 19, 2017, 02:58 PM)

Trying. Best Regards

-Contro (February 19, 2017, 03:36 PM)

I think I got. Is fast and easy. Best Regards

[Contro]

If you apply the description of my TED Notepad procedure, copy/pasting the 'Output mask' values from here, you should be fine, I think I see at least 3 typos in your first screenshot, and then it only gets worse from there...

-Ath (February 19, 2017, 02:36 PM)

I think very interesting to load a python script.
It's new for me.

Can I try again ?