Extract numerical value from string

[davidcarldesign]

Hi folks,

I’m trying to find a numerical value from the “Title” field and have it appear in the “amount” (e.g. 27.21)

I’ve used this formula from looking at a few post’s but it only copies the values before the decimal:

MID(
{Title},
FIND(
“For”,
{Title}
)

• 6, 50
  )

Another formula I found only copies the values before the decimal:

IF({Title}, VALUE(RIGHT({Title}, LEN({Title})- FIND(“0”,“1”,“2”,“3”,“4”,“5”,“6”,“7”,“8”,“9”, {Title}))), 0)

What formula do I need to get the full total which in this example is 27.21?

Thanks in advance!

:winking_face:

[davidcarldesign]

augmented:

VALUE(REGEX_EXTRACT({Title},’\d*\.?\d+’))

Mission Accomplished!

Thanks, you did it!