We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Truncating number from a string

sahasanb
7 - Meteor
‎11-01-2022 06:42 AM

I ma new in Alteryx. Please help me to find solution for attached scenario.

Preview file
9 KB
Labels:
Reply
0 Likes
3 REPLIES 3
DataNath
17 - Castor
17 - Castor
‎11-01-2022 02:22 PM

Hey @sahasanb, here's one way I'd go about this, using a regular expression to find a percentage in the string and parse that:

 

DataNath_0-1667337745402.png

Parse percentage rate from string.yxmd
Reply
acarter881
12 - Quasar
‎11-01-2022 02:29 PM

Hello @sahasanb.

 

Please see attached for one possible solution.

acarter881_0-1667338186955.png

 

trunc example.yxmd
Reply
0 Likes
binuacs
21 - Polaris
‎11-01-2022 03:05 PM

@sahasanb One way of doing this

REGEX_Replace([Name], '.*?(\d+%)', '$1')

binuacs_0-1667340287956.png

 

Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All