How to use awk sort by column 3

Question

I have a file (user.csv) like this

ip,hostname,user,group,encryption,aduser,adattr 

want to print all sorting columns by user,

I tried awk -F ":" '{print|"$3 sort -n"}' user.csv , it does not work.

Answer 1

How about just sort .

 sort -t, -nk3 user.csv 

Where

• -t, - defines your separator as,.

• -n - gives you a numerical look. Added since you added it in your attempt. If your user field is text, then you do not need it.

• -k3 - defines the field (key). user is the third field.

Answer 2

• Use awk to set the user ID.
• Sorting

• Use sed to remove the duplicate user ID, provided the user IDs do not contain spaces.

   awk -F, '{ print $3, $0 }' user.csv | sort | sed 's/^.* //' 

Answer 3

try it -

 awk '{print $0|"sort -t',' -nk3 "}' user.csv 

OR

 sort -t',' -nk3 user.csv 

Answer 4

You can choose a separator, in this case I select a colon and print column number one, sorting alphabetically.

 awk -f\: '{print $1|"sort -u"}' /etc/passwd 

Answer 5

 awk -F, '{ print $3, $0 }' user.csv | sort -nk2 

and for the reverse order

 awk -F, '{ print $3, $0 }' user.csv | sort -nrk2