mercredi 2 juillet 2014

Unique enties of a specific partial column of csv file


Vote count:

0




In a comma separated csv file,2nd column is 10 digit number(eg.7737480463). I am able to find out total number of unique entries for 2nd column by following command



awk -F, '{print $2}' abc.csv|sort|uniq|wc -l


But i want to find out total number of unique entries for 2nd column on the basis of first 5 digit(eg.77374).



asked 19 secs ago






Aucun commentaire:

Enregistrer un commentaire