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
Résolu ! Accéder à la 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
Dear @camie
thank you for your response .... I just want "1013.686"
if I use your formula the result is "11013686"
edited the reply above...
I have a lot to learn in order to utilize RegEx because I find it difficult to use.