Re: count in colum

I "cleaned it up" a little, using same idea.

head -1 infile > outfile
tail -n +2 infile | cut -d ';' -f 1 | uniq -c > counts
sed -r 's|\s*([0-9]*) ([0-9]*)|\2 ; \1 ;|' counts >> outfile

I still think it would be easier to work with if you did not have the spaces around the semicolons. :)

--- In [email protected], Thierry Blanc <Thierry.Blanc@...> wrote:
>
> try something like that
> 
> cut -d ';' -f 1 your_file | uniq -c | sed -r 's|\s*([0-9]*) 
> ([0-9]*)|\2;\1;|'
> 
> sed can't count, so use uniq to do the counting.
> 
> On 29/03/13 14:43, MOKRANI Rachid wrote:
> > Hi,
> >
> > Someone can give me a simple sed commande for doing the following.
> >
> > My file .
> >   
> > Num ; Count ;
> > 8 ; 1 ;
> > 9 ; 1 ;
> > 9 ; 1 ;
> > 9 ; 1 ;
> > 10 ; 1 ;
> > 10 ; 1 ;
> > 10 ; 1 ;
> > 11 ; 1 ;
> > 12 ; 1 ;
> > 12 ; 1 ;
> >
> > I would like the following result with sed.
> >
> > Num ; Count ;
> > 8 ; 1 ;
> > 9 ; 3 ;
> > 10 ; 3 ;
> > 11 ; 1 ;
> > 12 ; 2 ;
> >
> > Any help will be really appreciate.
> > Best regards.
> >
> > __________________________
> > Avant d'imprimer, pensez à l'environnement ! Please consider the environment before printing !
> > Ce message et toutes ses pièces jointes sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. IFP Energies nouvelles décline toute responsabilité au titre de ce message. This message and any attachments are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. IFP Energies nouvelles should not be liable for this message.
> > __________________________
> >
> >
> > ------------------------------------
> >
>