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.
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.
substitute really is quite a useful function!