UNIX for Dummies Questions & Answers

hi all,

i have file as below:

N000150100B00|1
N000150100B00|3
E0P2C42100000|2
E0P2C42100000|3
N000150100B00|2
N000150100B00|4
E0P2C42100000|3
E0P2C42100000|3
E0P2C42100000|6

now i want to compare 1st field of all rows with all other row's first field
and if they are same then i have to put that many records in one seperate file.

for example, compare N000150100B00 with all other.. same for all the records.

your help will be appreciated.

thx,
pranav

check if this is what you want:

Code:

sort  -t '|' -k1  /foo/bar | uniq -w 13 -d

.. to a new file with each 1st field and number of occurences:

Code:

sort  -t '|' infile| awk -F "|" '{ arr[$1]+=1 } END{for (ele in arr) { print ele,arr[ele] } }' > newfile