Can I sort IP addresses in numeric value

michalpl7

This post is deleted!

michalpl7

@PeterJones hello the problem with this command is that it also could change MAC address deletes “00” from it.

michalpl7

@Coises said in Can I sort IP addresses in numeric value:

1,2,3,4

Perfect! Thanks :)

PeterJones

@michalpl7 said in Can I sort IP addresses in numeric value:

it also could change MAC address deletes “00” from it

I was afraid you were going to realize that exception.

(?:^|\.)\K0+(?=\d+?(?=\.|\h))

This changes the requirement to whatever goes before the leading zero digits must be either start of line or a period. But because of the \K, you have to use Replace All (it will not work with a single Replace)

When I tried my old one on

192.168.001.020 d067-bc22-0004

it wrongly became

192.168.1.20 d067-bc22-4

but when I tried my modified expression, it correctly became

192.168.1.20 d067-bc22-0004

But if @Coises’s plugin solution works for you, I’d go that way, because it doesn’t involve as much complication, and ensures that it’s only dealing with the digits inside an IP address.

Jon

The Python solution hasn’t been discussed here and as that thread is very old I’ll post here.
… I need 1 reputation point to post links, so here it is - remove the spaces!
https:// community.notepad-plus-plus .org/topic/11105/feature-request-sort-by-ip-address-cidr-notation

Those scripts didn’t work for me so I wrote my own. This handles both IP & CIDR interchangeably.

import re

addresses = editor.getText().split('\n') # Contents to string array
 
non_blank_addresses = [] # Filter out blank lines
for addr in addresses:   #  and clean the input data using regular expressions.
  cleaned_addr = re.sub(r'\s', '', addr)  # Remove whitespace
  if cleaned_addr:       # Check if not empty
    non_blank_addresses.append(cleaned_addr)

# Sort all addresses (CIDRs and individual IPs)
sorted_addresses = sorted(non_blank_addresses, key=lambda addr: (
  tuple(map(int, re.split(r'[/.]', addr)))[:-1],  # Extract IP components
  int(re.split(r'[/.]', addr)[-1]) if '/' in addr else 32  # Extract and convert prefix length
))

editor.beginUndoAction()
editor.setText('\n'.join(sorted_addresses))
editor.endUndoAction()

Alan Kilborn

@Jon

This script will, perhaps quietly, corrupt a user’s file, because it changes line endings from Windows’ type (CRLF) to Linux type (LF). :-(

Mark Olson

@Alan-Kilborn said in Can I sort IP addresses in numeric value:

corrupt a user’s file, because it changes line endings from Windows’ type (CRLF) to Linux type (LF).

AlanKilborn is correct.

My practice in any file when I’m dumping lines is to do something like this:

# Near the top of the script (with other global constants)
EOLS = ('\r\n', '\r', '\n')
# code
#...
# whenever I want to choose newline, do this:
    eol = EOLS[editor.getEOLMode()]

Alan Kilborn

@Mark-Olson

My version of that is eol = ['\r\n', '\n', '\r'][editor.getEOLMode()]… the same, but all in one place.

Alan Kilborn

I spoke before of:

perhaps quietly, corrupt a user’s file

and then I presented some code which does just that. :-(

Instead of:

eol = ['\r\n', '\n', '\r'][editor.getEOLMode()]

in my posting immediately above, it should have been:

eol = ['\r\n', '\r', '\n'][editor.getEOLMode()]

(note that the '\r' and the '\n' were swapped in the erroneous code)

My apologies for the error.

supasillyass

@guy038 Edit > Line Operations > Sort Lines As Integers Ascending 😉

Oh wow, necro thread 💀