Extract Number

Ar13f

Dear All,

I ask for your help for the problem below, I want to take only the numbers, namely :

"abcd 1 PqDTwYY - ZooTrY,(1013.686 Meters)" ------> 1013.686

and I've used regex : ".+\((\d.*)\)" and the result is 1013.686 Meters but I can't get rid of the word "Meters"

Regards,

Ar1ef

Datasets

Regex

Accepted answers

camie

@Ar13f

if you want to extract all numbers present in your field you can try this: REGEX_Replace([Field1],"[^0-9]","")
[Field1] = "abcd 1 PqDTwYY - ZooTrY,(1013.686 Meters)"

or you can use regex tool

All comments

camie

@Ar13f

if you want to extract all numbers present in your field you can try this: REGEX_Replace([Field1],"[^0-9]","")
[Field1] = "abcd 1 PqDTwYY - ZooTrY,(1013.686 Meters)"