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
Solved! Go to Solution.
Perfect! Thank you