Start Free Trial

Alteryx Designer Desktop Discussions

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

Extract number from the middle of a sentence

D_Y
8 - Asteroid

I have a sentence that looks something like this:

 

We have assessed a value of 10% for this item.

 

How can I use Alteryx to parse the 10% from this sentence (that was fully within one cell)?

3 REPLIES 3
binu_acs
21 - Polaris

@D_Y one way of doing this

image.png

flying008
15 - Aurora

Hi, @D_Y 

 

Are you sure that your sentence only contains one numerical value like 10% ?

D_Y
8 - Asteroid

Thank you!

Labels
Top Solution Authors