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

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

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

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

acarter881
12 - Quasar

Hello @sahasanb.

 

Please see attached for one possible solution.

acarter881_0-1667338186955.png

 

binu_acs
21 - Polaris

@sahasanb One way of doing this

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

binuacs_0-1667340287956.png

 

Labels
Top Solution Authors