Help in counting integers within a rollup field array

[corb1]

I have a list of unique ID+count information in a rollup field. See sample data below.

16389-0*4, 70895-0*2, 53429-0*2, .....

Everything before the * is an ID, and the integer following the * is a count for that ID. I would like to strip everything prior to the star, leaving:

4,2,2,....

Then I'd like to sum those values.

Is that possible?

[TheTimeSavingCo]

You'll need to add a formula field to your data table that cleans up the data for you, and then use a rollup field with `SUM(values)` in the other

Formula used:

SUBSTITUTE(
  Name,
  LEFT(
    Name,
    FIND(
      "*",
      Name
    )
  ),
  ""
)

  

Link to base

[corb1]

This is good for single elements (like you have above in your Name column). As follows:

16389-0*4

70895-0*2

53429-0*2

My issue is I have an array of data elements as follows:

16389-0*4, 70895-0*2, 53429-0*2

[TheTimeSavingCo]

Hm, okay.  Could you share screenshots of the relevant tables and fields please?