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

[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!