Regex Replace formula usage in formula tool

[vamsey]

Hi Everyone,

I have data in the format mentioned below and I want to extract only the numbers in parenthesis using regex replace formula in formula tool. Can anyone help me.

Available Unutilized X Rate(0.44%)
Unutilized X Rate(0.25%)
Unutilized X Rate(0.25%)
Unutilized X Rate(0.25%)
Unutilized X Rate(0.625%)

[atcodedog05]

Hi @vamsey 

Here is how you can do it.

Workflow:

Hope this helps : )

[vamsey]

Hi  atcodedog05

Thanks for the reply.

When i'm changing the data type of output to float and viewing the data in the browse tool, it's not showing the same result as output.

Can you look into this.

[atcodedog05 · Accepted solution]

Hi @vamsey 

Not sure. Can you try the attached workflow.

Hope this helps : )

[vamsey]

Thanks a lot 🙂

It helped 😄

[atcodedog05]

Happy to help : ) @vamsey 

Cheers and have a nice day!