Help

How to extract numbers operation from a string?

Topic Labels: Formulas
722 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Seb_Blandin
4 - Data Explorer
4 - Data Explorer

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