Text Analysis

[bmillrine]

Hi all

I want to extract out certain information from the body of an email.

Text

Morning, Please can you Invoice the following days for WE 10 12 17 -  5 Days at a rate of £36 per hour

Output I would like

Weekending - 101217

Days - 5

Rate - 36

I can parse out numbers using RegEx but I need to know how to say:

Numbers appear after WE therefore these are the weekending numbers

5  appears before Days so associated with days

35 is next to £ therefore monetary

Thanks

[andre347 · Accepted solution]

See attached a solution. I used three Regex tools so it's easier to understand but it's possible to do this into one. Created in v11.7

[bmillrine]

Perfect! Thank you