Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Help Splitting Data

HongAlt
6 - Meteoroid

1.JPG

 

Hi There,

 

How would I split the data using the RegEx Function?

I need to split the header from the Body.

The start of the Body would be Where it says "Subject" 

 

Not very familiar with this function and not sure what is the correct regular expression to use to achieve this. Thank you 

14 REPLIES 14
DataNath
17 - Castor
17 - Castor

Brilliant, thanks a lot @HongAlt - how does this look?

 

DataNath_0-1667430984724.png

HongAlt
6 - Meteoroid

@DataNath Thank you so much! I don't think I could have ever figured out this expression myself 

DataNath
17 - Castor
17 - Castor

Always happy to help @HongAlt! If you'd like to know what's going on here then feel free to let me know. However, if this is a one off need and you don't have a need for it any other time then I realise that a breakdown may be a little redundant!

I know RegEx can look a bit daunting at times and it certainly took a while for the penny to even start dropping. That said, the expression here is actually quite simple (certainly helped by the fact that a few key parts are hard coded in) but I can appreciate that the additional symbols etc can make it look very technical. 

HongAlt
6 - Meteoroid

@DataNath 

 

Thank you so much again for the help, it is a one-time thing for a part of a project. I will go through the expression and see if I can better interpret it myself. If I run into any issues, I will let you know. I may need help on other parts later on as this project has multiple parts, I hope that is ok. 

grazitti_sapna
17 - Castor

Hello @HongAlt, I have updated your workflow to parse EmailHeader. And do remember to accept my solution if you consider it useful.

grazitti_sapna_0-1667444729092.png

 

Sapna Gupta
Labels
Top Solution Authors