Regex Replace formula usage in formula tool

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%)

Regex

Accepted answers

atcodedog05

Hi @vamsey

Not sure. Can you try the attached workflow.

Hope this helps : )

utilized.yxmd

All comments

atcodedog05

Hi @vamsey

Here is how you can do it.

Workflow:

Hope this helps : )

utilized.yxmd

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.

vamsey

Thanks a lot 🙂

It helped 😄

atcodedog05

Happy to help : ) @vamsey

Cheers and have a nice day!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703