Skip to main content

Extract numerical values to find total sum from string

  • May 30, 2021
  • 1 reply
  • 25 views

I am new and teaching myself databases and AirTable so please be gentle. :grinning_face_with_big_eyes:

I am trying to extract the numbers from the {Recipe} column and add them all together to figure out the total number of drops for each blend. Is it possible to do this with my current setup? I have figured out how to extract the numbers but it just smooshes the numbers to become a 2-6+ digit number.

I hope this makes sense.

1 reply

Forum|alt.badge.img+17

Yes, use Value() to parse the floats. And welcome to the community!