https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165512#M681544 Thread closed! Tue, 24 Mar 2009 13:19:07 GMT Robert-Jan Goossens_1 2009-03-24T13:19:07Z https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165505#M681537 Below is a list of multipath devices (luns), is possible to sort the list based on the serial?<BR /><BR /># egrep -e "Serial|Unformatted" /tmp/rj-lun<BR /> Serial Num: 10328022C008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022C008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022D008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022D008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022E008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022E008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022F008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022F008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280230008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280230008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280231008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280231008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280232008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280232008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280233008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280233008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280234008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280234008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280235008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280235008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280236008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280236008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280237008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280237008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280238008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280238008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280F3C000<BR /> Unformatted capacity: 51937.500 MBytes<BR /> Serial Num: 103280F3C000<BR /> Unformatted capacity: 51937.500 MBytes<BR /> Serial Num: 103280F3E000<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280F3E000<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022C008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022C008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022D008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022D008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022E008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022E008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022F008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022F008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280230008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280230008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280231008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280231008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280232008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280232008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280233008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280233008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280234008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280234008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280235008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280235008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280236008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280236008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280237008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280237008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280238008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280238008<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280F3C000<BR /> Unformatted capacity: 51937.500 MBytes<BR /> Serial Num: 103280F3C000<BR /> Unformatted capacity: 51937.500 MBytes<BR /> Serial Num: 103280F3E000<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280F3E000<BR /> Unformatted capacity: 25968.750 MBytes<BR /><BR />Regards,<BR />Robert-Jan Mon, 23 Mar 2009 12:47:42 GMT https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165505#M681537 Robert-Jan Goossens_1 2009-03-23T12:47:42Z https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165506#M681538 Hi Robert-Jan:<BR /><BR />If the issue is that each line shown is a separate line, then join the lines and pipe them to a sort:<BR /><BR /># paste -s -d"\t\n" | sort -k3,3<BR /><BR />Regards!<BR /><BR />...JRF...<BR /> Mon, 23 Mar 2009 13:15:45 GMT https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165506#M681538 James R. Ferguson 2009-03-23T13:15:45Z https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165507#M681539 Hi (again):<BR /><BR /># paste -s -d"\t\n" | sort -u -k3,3<BR /><BR />...since your subject line suggested unique values, too.<BR /><BR />Regards!<BR /><BR />...JRF... Mon, 23 Mar 2009 13:17:10 GMT https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165507#M681539 James R. Ferguson 2009-03-23T13:17:10Z https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165508#M681540 Thanks for your time James!<BR /><BR />This is the information I need but I will loose the combined serial size info about the lun. <BR /><BR /># paste -s -d"\t\n" | sort -u -k3,3 /tmp/rj-lun2<BR /> Serial Num: 10328022C008<BR /> Serial Num: 10328022D008<BR /> Serial Num: 10328022E008<BR /> Serial Num: 10328022F008<BR /> Serial Num: 103280230008<BR /> Serial Num: 103280231008<BR /> Serial Num: 103280232008<BR /> Serial Num: 103280233008<BR /> Serial Num: 103280234008<BR /> Serial Num: 103280235008<BR /> Serial Num: 103280236008<BR /> Serial Num: 103280237008<BR /> Serial Num: 103280238008<BR /> Serial Num: 103280F3C000<BR /> Serial Num: 103280F3E000<BR /> Unformatted capacity: 25968.750 MBytes<BR /> Unformatted capacity: 51937.500 MBytes<BR /><BR />Regards,<BR />Robert-Jan Mon, 23 Mar 2009 13:27:44 GMT https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165508#M681540 Robert-Jan Goossens_1 2009-03-23T13:27:44Z https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165509#M681541 Hi (again) Robert-Jan:<BR /><BR />I meant to write thusly:<BR /><BR /># paste -s -d"\t\n" file | sort -k3,3<BR /><BR />or:<BR /><BR /># paste -s -d"\t\n" file | sort -u -k3,3<BR /><BR />Regards!<BR /><BR />...JRF... Mon, 23 Mar 2009 13:31:21 GMT https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165509#M681541 James R. Ferguson 2009-03-23T13:31:21Z https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165510#M681542 Thanks a lot James!<BR /><BR /># paste -s -d"\t\n" /tmp/rj-lun2 | sort -u -k3,3<BR /> Serial Num: 10328022C008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022D008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022E008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 10328022F008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280230008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280231008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280232008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280233008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280234008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280235008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280236008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280237008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280238008 Unformatted capacity: 25968.750 MBytes<BR /> Serial Num: 103280F3C000 Unformatted capacity: 51937.500 MBytes<BR /> Serial Num: 103280F3E000 Unformatted capacity: 25968.750 MBytes Mon, 23 Mar 2009 13:38:15 GMT https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165510#M681542 Robert-Jan Goossens_1 2009-03-23T13:38:15Z https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165511#M681543 <!--!*#-->Another solution with awk:<BR /><BR />awk '/Serial/ {getline line;print $0,line}' FILENAME | sort -n -k 3<BR /><BR /> Tue, 24 Mar 2009 12:40:45 GMT https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165511#M681543 Viktor Balogh 2009-03-24T12:40:45Z https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165512#M681544 Thread closed! Tue, 24 Mar 2009 13:19:07 GMT https://community.hpe.com/t5/operating-system-hp-ux/uniq-sort-question/m-p/5165512#M681544 Robert-Jan Goossens_1 2009-03-24T13:19:07Z