How to count char

[muniyandi]

Hi,

how to count the char, how many times in the field.

Ex: ('abcd,efgh,ijklm,nopqrs,tuvwxyz',',') i want Result  4

('abcd,efgh,ijklm,nopqrs,tuvwxyz','a') i want result 1

Thanks,

Muni

[sunilkumarqv]

We are not geeting you Please explore what need to ask

[#3]

try

substringcount( text , substring)

Returns the number of times the string substring appears within the string text. The result is an integer. If there is no match, 0 is returned

Example:

substringcount ( 'abcdefgcdxyz', 'cd' ) returns 2

[Sokkorn · Accepted solution]

Hi Muni,

=SubStringCount('abcd,efgh,ijklm,nopqrs,tuvwxyz',',') -> will return 4

=SubStringCount('abcd,efgh,ijklm,nopqrs,tuvwxyz','a') -> return 1

Regards,

Sokkorn

[#5]

hi

substringcount( text , substring)

Returns the number of times the string substring appears within the string text. The result is an integer. If there is no match, 0 is returned

Example:

substringcount ( 'abcdefgcdxyz', 'cd' ) returns 2

[sunilkumarqv]

Sokkorn is correct

[#7]

Hi Mathew,

Let Inde=IndexLet Inde1=Index('abcd,efgh,ijklm,nopqrs,tuvwxyz','a');

Let Inde1=Index(''abcd,efgh,ijklm,nopqrs,tuvwxyz','a',1);

Let Inde2=Index(''abcd,efgh,ijklm,nopqrs,tuvwxyz','a',2);

Hope this will help you

Regards,

DJ

[muniyandi]

Hi All,

Sokkorn answer is correct

Thanks to all.

Muni