RegEx - Number between ()

[sahartz]

Hi,

I have these expressions: 

Level 11 (0.90%) 

Level 1 (2%)

and I want only the number 0.90 and 2

Can you assist?

Thanks :)

[DataNath]

\((.*)%

Should do the trick!

[IraWatt]

Hey @sahartz,

I agree with @DataNath, \((.*)% should do the trick!

essentially the \ at the beginning acts as an escape character for the ( meaning that the ( acts as a normal character not as a marked group. Then the (.*) is your market group. So the statement essentially says any characters between a ( and a % sign. regex101: build, test, and debug regex is a great website for learning and searching for common regex. 

HTH,

Ira

[binuacs]

@sahartz one way of doing this

REGEX_Replace([Input], '.*\((.*)%.+', '$1')

[apathetichell]

regex_replace([Input],".*\((\d*\.*\d*).*\).*","$1",0)

there are lot of unknowns from your description - so some of the other solutions might not work. Depending upon how your full dataset is formatted all or none of these solutions might work.