Free Trial

Alteryx Designer Desktop Discussions

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

How to extract number from a paragraph

D_Y
8 - Asteroid

I have two types of sentences that look like this:

 

For the mall, we have used an estimate of 1.0% of sales, in the overall analysis. In the specific analysis method, we have used an estimate of 4.0% of sales, but excluded one store from the analysis. In this analysis, we have also added a certain level of assumptions for 1 of the stores. 

 

 

For the apartment, we have used an estimate of 2.0% of sales, in both the overall analysis and the specific analysis. In this analysis, we have also added a certain level of assumptions for 2 of the stores.

 

How do I extract the numbers 4.0% and 2.0% from these two paragraphs?

1 REPLY 1
ChrisTX
16 - Nebula
16 - Nebula

Use the RegEx tool in Parse mode with this expression:

 

.*(\d\.\d%).*

 

The website https://regex101.com/  is helpful.

 

Chris

Labels
Top Solution Authors