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?
Solved! Go to Solution.
Use the RegEx tool in Parse mode with this expression:
.*(\d\.\d%).*
The website https://regex101.com/ is helpful.
Chris