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.

Regex in <> characters

miglema
5 - Atom

Hello,

 

I have a set of data from Outlook inbox where specific answers are separated by <> characters, for example:

 

<Name of the company> <MB Lala>
<Company code> <99999999>
<Invoice for month:> <april>
<Contact person> <Name Surname>
<Phone number> <+3700000000>
<Email> <info@example.com>

Could anyone help by saying whether or not these answers in denoted brackets (<>) can be retrieved fully while using Regex? How should the Syntax look like?

 

Thank you so much!

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

Hey @miglema,

Ive attached two ways of taking the values out of the xml. One with Regex and the other just splitting to columns. Hope this answers your question? If you want further details on how this works feel free to ask :)

IraWatt_1-1651080452471.png

 

All the best,

Ira

Qiu
21 - Polaris
21 - Polaris

@miglema 
Similar with solution from @IraWatt , but I removed the "<>" .
I use this website to create and test RegEx.

https://regex101.com/

0428-miglema-1.PNG0428-miglema-2.PNG

Labels
Top Solution Authors