Awk Plus sort implements a key for the first N-1 field and the last field as the value sort

Recently there are some data, such as:

a1,asdff,dddd,23

zz,ss,ff,hh,kk,56

pppp,90

wwww,qqq,eee,ttt,yyy,44

Such data, need to be the previous N-1 fields as key, the last field to do value, and according to the value of the sort, pondering for a long time, finally initially implemented, so in this note and share:

awk ' begin{fs= ', "; ofs= "  "}{<span style= "White-space:pre" ></span>for (i=1;i<nf;i++) {<span style= "White-space: Pre "></span>if (i==1) <span style=" White-space:pre "></span>u= $i <span style=" White-space: Pre "></span>else<span style=" White-space:pre "></span>u= (U", "$i) <span style=" White-space: Pre "></span>};<span style=" White-space:pre "></span>print U, $NF} ' In.txt|sort-r-n-k2  

Awk Plus sort implements a key for the first N-1 field and the last field as the value sort