If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Counting substring occurences in a string

Started by mjklunk, 31 Oct 2013 03:58:54 PM

Previous topic - Next topic

mjklunk

I am looking for a way to count the number of times 'SL' occurs in a string such as 'SL,CR,SL,LT,PK'

blom0344

compare the length of the original string value to a dataitem that defines a replace of SL with '' (empty string) and divide the difference by 2