I'm trying to create a workflow that reads from emails with Outlook tool but I'm trying to get specific information in the body of the email. Is anyone able to point me in the right direction? I've tried searching for prior discussions and haven't had any luck.
Does anyone know how to pull out the text following "Apples:" and "Bananas:" Please see sample email below:
"Good morning,
This is the body of the email.
Grapes:
Red: 22
Green: 30
Apples:
Red: 4
Green: 0
Yellow: 1
Bananas:
Yellow: 10
Brown: 1
Thank you"
Hey @Grisham312, it's not too pretty but if you're only looking for specific parts of the body then hard-coding etc starts to become a bit necessary:
Hi, @Grisham312
Looking at your data, I want to organize it a little more as below...
Workflow
Output
Regular Expression in Regex Tool
([a-zA-Z]+:[\d\s]*)
I hope you like it.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |