Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regex Replace formula usage in formula tool

vamsey
8 - Asteroid

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

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @vamsey 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1633019374148.png

 

Hope this helps : )

vamsey
8 - Asteroid

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_0-1633021075648.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @vamsey 

 

Not sure. Can you try the attached workflow.

 

Hope this helps : )

vamsey
8 - Asteroid

Thanks a lot 🙂

It helped 😄

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @vamsey 

Cheers and have a nice day!

Labels
Top Solution Authors