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

[camie · Accepted solution]

@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

[binuacs]

@Ar13f one of doing this with the Regex Tool

[Ar13f]

Dear @camie 

thank you for your response .... I just want "1013.686" 

if I use your formula the result is "11013686"

[binuacs]

@Ar13f Another way of dong this with the Regex_Replace function

REGEX_Replace([F1], '[^\d+\.]', '')

[camie]

edited the reply above...

[Ar13f]

Dear @camie 

thank you ... solved

[Ar13f]

Dear @binuacs 

thank you for suggestion ... but I need just "1013.686"

[Ar13f]

I have a lot to learn in order to utilize RegEx because I find it difficult to use.