How to count a particular Character in a String

sunnyk

Hi,
How can i find the Count of a character appeared in a string.
For example suppose i have a string ABCDEFG@Yahoo.com,XYZ123@Yahoo.co.uk then if i want to find the Number of '@'. how can i do this using string function.

mohana_cse06

Searches for the first occurrence of substring inside a string.

Position := STRPOS(String, SubString)

PS:use F1 or search before posting

sunnyk

Dear Mohana,
I used F1 but didn't found any function which count the occurrence of a character in a String.
STRPOS gives the position of that character in a string and not the no of times that character appears in a string.

mohana_cse06

sunnyk wrote:

Dear Mohana,
I used F1 but didn't found any function which count the occurrence of a character in a String.
STRPOS gives the position of that character in a string and not the no of times that character appears in a string.

#-o #-o
[-( [-(

matteo_montanari

sunnyk wrote:

Hi,
How can i find the Count of a character appeared in a string.
For example suppose i have a string ABCDEFG@Yahoo.com,XYZ123@Yahoo.co.uk then if i want to find the Number of '@'. how can i do this using string function.

Hi

TextLine := 'yourtext';
STRLEN(DELCHR(TextLine, '<=>', DELCHR(TextLine,'<=>', '@')));

Bye

Matteo

Belias

STRLEN(DELCHR(TextLine, '=', DELCHR(TextLine,'=', '@')));

this is enough (without '<' and '>'...)

sunnyk

Thank you :thumbsup:

Ephraim_07

Belias wrote: »

STRLEN(DELCHR(TextLine, '=', DELCHR(TextLine,'=', '@')));

this is enough (without '<' and '>'...)

This worked perfectly. Thanks