Sum all numbers found in text

Is it possible for AppSheet to provide a sum of numbers found in text as a value in a virtual column?

If I get a Form entry of "500 registration, 500 travel, 120 per diem" is there an expression I can use so that the aforementioned virtual column populates with 1120?

Simply providing options for separate entries for these values isn't an option, there will be too many possible variables. I didn't create the form, but I have to use its results.

Solved Solved
0 2 101
1 ACCEPTED SOLUTION

2 REPLIES 2

Nailed it. Thank you. I've been thrown to the wolves as it were and I appreciate your help!

Top Labels in this Space