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 column sort by user,

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

Answer 1

How about just sort.

sort -t, -nk3 user.csv 

where

• -t, - defines your delimiter as ,.

• -n - gives you numerical sort. Added since you added it in your attempt. If your user field is text only then you dont need it.

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

Answer 2

1. Use awk to put the user ID in front.
2. Sort

3. Use sed to remove the duplicate user ID, assuming user IDs do not contain any spaces.

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