Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to extract numbers operation from a string?

Topic Labels: Formulas
768 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