[SOLVED] Sort problem

battles · 06-10-2014, 07:09 AM

I am trying to sort the iptables output and am not getting the results I want. I am trying to sort by ip addresses.

iptables -L -n -v --line-numbers | sort -n --key=53,55

My results:

10 15 608 DROP all -- * * 220.???.0.0/16 0.0.0.0/0
11 0 0 DROP all -- * * 173..???..120.242 0.0.0.0/0
12 2 104 DROP all -- * * 69..???..33.173 0.0.0.0/0
13 0 0 DROP all -- * * 202..???..54.8 0.0.0.0/0

The IPs are not sorting. It seems that the whole line is sorting.

dayid · 06-10-2014, 07:22 AM

What are you actually trying to accomplish by doing this? This is a case of the X/Y Problem. By knowing what you're actually trying to accomplish (overall) you are more likely to get the correct help.

syg00 · 06-10-2014, 07:28 AM

First off, things would be a whole lot easier (for us) if you used [code] tags - like this

Code:

10      15   608 DROP       all  --  *      *       220.???.0.0/16       0.0.0.0/0
11       0     0 DROP       all  --  *      *       173..???..120.242    0.0.0.0/0
12       2   104 DROP       all  --  *      *       69..???..33.173      0.0.0.0/0
13       0     0 DROP       all  --  *      *       202..???..54.8       0.0.0.0/0

Next, you'd better read the manpage for a definition of KEYDEF (and --field-separator). That might help you understand what's happening with your attempt. As it happens, if you get "k" right, looks like it should be plain sailing.

battles · 06-10-2014, 07:49 AM

Just discovered that you are dealing with columns, not data positions. This works.

iptables -L -n -v --line-numbers | sort -n -k9