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

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…