Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to extract numbers operation from a string?

Topic Labels: Formulas
284 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone,
I receive in a single text field this kind of data:
+1 * 1+0 * 2+0 * 3+0 * 4+0 * 5+0 * 6+0 * 7+0 * 8+0 * 9+0 * 10
or
+1 * 4+1 * 5+0 * 6+0 * 7

This is the number of kilos that needs to be sent in the appropriate package. I wonder how I could retrieve the 1*1 from the first line, or, for the second line, 1 * 4 and 1 * 5

I was thinking about some regex expression but my knowledge is poor in that field. Anyone would have an advice?

Thanks in advance

0 Replies 0