Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Discussions

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

Parse exact text in string and following text from Body of email

Grisham312
6 - Meteoroid

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"

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

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:

 

DataNath_0-1680797601409.png

binuacs
21 - Polaris

@Grisham312 One way of doing this

binuacs_0-1680817794125.png

 

Yoshiro_Fujimori
15 - Aurora

Hi, @Grisham312 

 

Looking at your data, I want to organize it a little more as below...

 

Workflow

Yoshiro_Fujimori_0-1680823488808.png

Output

Yoshiro_Fujimori_1-1680823506594.png

 

Regular Expression in Regex Tool

([a-zA-Z]+:[\d\s]*)

 

I hope you like it.

Labels