MQSeries.net :: View topic - Counting the number of occurences of a character in a String

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Counting the number of occurences of a character in a String

Counting the number of occurences of a character in a String

« View previous topic :: View next topic »

Author

Message

vairavan

Posted: Tue Jan 13, 2009 10:05 am Post subject: Counting the number of occurences of a character in a String

Apprentice

Joined: 22 Apr 2008
Posts: 42

Hi,

Can anybody help me in getting the number of occurences of a character in a String?

For Example:
String s= 'ABCABABABABA';

It should give 6

Any comments will be appreciated...

vairavan

Posted: Tue Jan 13, 2009 1:14 pm Post subject: Counting the number of occurences of a character in a String

Apprentice

Joined: 22 Apr 2008
Posts: 42

Hi,

Can anybody help me in getting the number of occurences of a character in a String using ESQL?

For Example:
String s= 'ABCABABABABA';

It should give 6

Any comments will be appreciated...

madi

Posted: Tue Jan 13, 2009 1:19 pm Post subject:

Chevalier

Joined: 17 Jan 2006
Posts: 475

I don't think there is direct function that can do that within esql. But I may be wrong.

--madi
_________________
IBM Certified Solutions Developer - WMB 6.0

kimbert

Posted: Tue Jan 13, 2009 1:31 pm Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Why do you want to do that?

mqjeff

Posted: Tue Jan 13, 2009 2:10 pm Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

madi wrote:

I don't think there is direct function that can do that within esql. But I may be wrong.

--madi

There's a simple composition of overlay and length.

sarathmattam

Posted: Tue Jan 13, 2009 6:53 pm Post subject:

Voyager

Joined: 05 Sep 2008
Posts: 94

I think you can use POSITION function to achieve this .. Do it in a loop.. i am not sure whether its the best method .. But it works..

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Counting the number of occurences of a character in a String

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP