Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Extract number?

Topic Labels: Formulas
162 3
Showing results for 
Search instead for 
Did you mean: 

Hi Expert, i have a field which keep a product volume, for example , 20g, 30ml, 45piece, 150l, 8pack.

i just want to extract the numbers, so the after formula field will be , 20,30,45,150,8.

i try to think and search for a while but have no idea how to do it , any advise??


3 Replies 3

You could try creating a formula field with this formula:

VALUE({Your field Name})

But you should note that VALUE() doesn’t always work properly, though. Even though it is supposed to return only the numbers from a field, it actually often performs math & mathematical conversions, so it is very unreliable. You will need to test it for your purposes to see if it works reliably enough for your needs.

Hi Louis, I’ve set something up here for you to check out

Screenshot 2022-08-11 at 8.09.39 PM

It uses regex which I’m not that familiar with, but it seems to do the trick

REGEX_EXTRACT(Name, "\\d+")

it really works, thanks mate!!