How to keep just the numbers in a certain string?

Hi there,

How can I just keep the numbers ina certain string, for example:

address = "Maistraße 37" or address = "64 Redemarsh"

On the first example I want to get 37 and the on the second 64, is this possible using the trim function? if yes, how? or is there any other way?

Thanks in advance.

Susana

Accepted answers

Try this

REGEX_Replace([Address], "[\D]", "")

It uses regex to replace anything that is not a digit with a blank string.

Try this

REGEX_Replace([Address], "[\D]", "")

It uses regex to replace anything that is not a digit with a blank string.

Thanks a lot! It works perfectly

Hello,

How would this work if you also want to keep decimals . For example, "Bonus 3,5%" => 3.5. Using this formula above I will get 35.

Many thanks,

Casper

Thanks. It works for me.