How to find no of strings in a concatenated string

tejaswini

Hi Everyone,

I have line items which is the concatenated string

ex - 123,435,234,678,567,987

I would like to find no of strings present ie 6

Could you please help me with this.

Thanks

Tejaswini

Accepted answers

All comments

Ingilavicus

Hi @tejaswini ,

As Anaplan doesn't have a native text counting formula you can use this workaround to find the number of separators in the concatenation, thus giving the number of items concatenated:

Number of seperators = LEN(Text) - LEN(SUBSTITUTE(Text, ",", "")) = 5

This will give you the number of separators in your case "," in the string, then just do +1 for the number of original items concatenated.

Andris

andrewtye

substitute really is quite a useful function!

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…