Calculating number of records by field

Shell Programming and Scripting
1

Hi,

I have CSV file which looks like below, i want to calulate number of records for each brand say SOLO_UNBEATABLE E and SOLO_UNBEATABLE F combined and record count is say 20 . i want to calculate for each brand, and here only first record will have all data and rest of record for the brand is with only two fields displayed.
Let me know how i can number of records for such situation ?

SOLO_UNBEATABLE	E	7	5/1/2010 13:00	5/6/2010 18:00	12:30	17:00	2263881188	Y	41216		Free Solo msg: Your monthly charge is past due. Top up now to reinstate your plan & avoid pay per use charges. Visit solomobile.ca/top-up. 						Sorry	 this address cannot receive incoming messages. Thank you for choosing Solo. To contact us	 visit solomobile.ca/contact-us	
							2263881964	Y												
							2263884224	Y												
							2263884246	Y
SOLO_UNBEATABLE	F	7	5/1/2010 13:00	5/6/2010 18:00	12:30	17:00	4162005872	Y	41216		Mess grat de Solo: Frais mensuels �chus. R�approvisionnez votre compte & �viter de payer � l'util. D�tails: solomobile.ca/reapprovisionner. 						D�sol�. Cette adresse ne peut recevoir de messages. Merci d'avoir choisi Solo. Visitez solomobile.ca/contactez-nous
							4183329551	Y									
							4184807455	Y									
							4185169291	Y									
							4185701898	Y									
							4185717607	Y									
Bell_BB	E	7	5/1/2010 13:00	5/6/2010 18:00	12:30	17:00	2506503556	Y	41216		Free Bell Msg: Your monthly payment is past due. Top up to reinstate your BlackBerry feature (may take 24 hrs). Visit bell.ca/topup						Sorry	 this address cannot receive incoming messages. Thank you for choosing Solo. To contact us	 visit solomobile.ca/contact-us
							2509368323	Y											
							2509475405	Y											
							2892609313	Y											
							2893562015	Y											
							4034781779	Y											
							4038210219	Y											
							5196517632	Y											
							6047039761	Y											
							6133189211	Y											
							6134309448	Y											
							9022473696	Y											
							9053517625	Y											
							9059121573	Y											
Bell_BB	F	7	5/1/2010 13:00	5/6/2010 18:00	12:30	17:00	5147182000	Y	41216		Mess grat Bell : Paiement mensuel en retard. R�app. � bell.ca/reapprovisionnement pour r�tablir votre option BlackBerry (peut prendre 24 h). 						D�sol�. Cette adresse ne peut recevoir de messages. Merci d'avoir choisi Solo. Visitez solomobile.ca/contactez-nous		
Bell_MONTHLY	E	7	5/1/2010 13:00	5/6/2010 18:00	12:30	17:00	2263883220	Y	41216		Free Bell msg: Your monthly charge is past due. Top up now to reinstate your plan & avoid pay per use charges. Visit bell.ca/topup. 						Sorry	 this address cannot receive incoming messages. Thank you for choosing Solo. To contact us	 visit solomobile.ca/contact-us
							2267475054	Y											
							2267477589	Y											
							2267484229	Y											
							2267488725	Y											
							2267489010	Y											
							2267493332	Y											
Bell_MONTHLY	F	7	5/1/2010 13:00	5/6/2010 18:00	12:30	17:00	4183343530	Y	41216		Mess grat de Bell: Frais mensuels �chus. R�approvisionnez votre compte & �viter de payer � l'util. D�tails: bell.ca/reapprovisionnement						D�sol�. Cette adresse ne peut recevoir de messages. Merci d'avoir choisi Solo. Visitez solomobile.ca/contactez-nous
							4187142083	Y									
							4188127848	Y									
							4189051790	Y									
							4189529341	Y									
							4189575309	Y									
							4189604983	Y									
							4505613682	Y									
							4505664580	Y
2

Give your expect output. Otherwise difficult to understand your request.

For example, how can you get the record count of 20 for SOLO_UNBEATABLE E and SOLO_UNBEATABLE F

3

I got solution to requirement

BEGIN {FS=",";count=0;}

{
if ( NR == 1 )
   { next;
   }

if ($1 != "" )
    {
    if(NR != 2 ) { print prev_serv_list,count; }
    prev_serv_list=$1;
    count=0 ;

    }
    count++
}

END {
print prev_serv_list,count;
}