How to count a particular Character in a String

sunnyk · 2009-10-29

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 · 2009-10-29

Searches for the first occurrence of substring inside a string.

Position := STRPOS(String, SubString)

PS:use F1 or search before posting

sunnyk · 2009-10-29

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 · 2009-10-29

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 · 2009-10-29

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 · 2009-10-29

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

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

sunnyk · 2009-10-30

Thank you :thumbsup:

Ephraim_07 · 2023-03-04

Belias wrote: »
STRLEN(DELCHR(TextLine, '=', DELCHR(TextLine,'=', '@')));
this is enough (without '<' and '>'...)

This worked perfectly. Thanks

Howdy, Stranger!

Quick Links

Categories

How to count a particular Character in a String

Answers