Find numbers in a string

Hi Experts,

I am struggling to get numbers from a string value. Here's the requirement:

sample data in table column:

I have 52 pens

My 52 pens are brand new

Total number of pens is 52

for each row of above sample - i need to get the value '52'

Saw some functions suggesting how to implement a isNumeric check but here i need to pick the numeric value only

from a bunch of words and not just check if it is numeric data or not.

Any suggestions on what can be done?

Thanks

Regards

VN