Re: find out how many times particular character occur in given string.

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 11 Dec 2008 18:52:44 -0600
Message-ID: <HBi0l.9729$yr3.3531@nlpi068.nbdc.sbc.com>


Noons wrote:
> Radoulov, Dimitre wrote,on my timestamp of 11/12/2008 11:30 PM:

>> Mladen Gogala wrote:
>>> On Wed, 10 Dec 2008 05:19:20 -0800, Sanjeev wrote:
>>>
>>>> Dear Gurus,
>>>>
>>>>   I want to find out how many times particular character occur in
>>>> given string.
>>>>   e.g. 'A*B*C*D*E*F' count of '*' is 5
>>>>          'A*B*C*D' count of '*' is 3
>>>>          'A' count of '*' is 0
>> [...]
>>>
>>> You can also do that in Perl:
>>>
>>> perl -e '$a="A*B*C*D*E*F"; print scalar(split(/\*/,$a))-1,"\n";'
>> [...]
>>
>> Or even:
>>
>> perl -le'print shift=~tr/*//' 'A*B*C*D*E*F'
>>
>>
>>
>> Regards
>> Dimitre

>
>
>
> If someone suggests it in awk,
> I'm gonna have a fit...

They did - when this question was asked in c.d.mysql ;) Received on Thu Dec 11 2008 - 18:52:44 CST

Original text of this message