SOLVED
Regex Replace formula usage in formula tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
vamsey
8 - Asteroid
‎09-30-2021
09:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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%)
Solved! Go to Solution.
Labels:
- Labels:
- Regex
5 REPLIES 5
22 - Nova
‎09-30-2021
09:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-30-2021
09:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
22 - Nova
‎09-30-2021
10:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-30-2021
10:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot 🙂
It helped 😄
22 - Nova
‎09-30-2021
10:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @vamsey
Cheers and have a nice day!
![](/skins/images/59DA3CA97FC6306BFE8B6DED203F3AC0/responsive_peak/images/icon_anonymous_message.png)