Alteryx Designer Desktop Discussions

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

Regex in <> characters

miglema
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 ANTWORTEN 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
20 - Arcturus
20 - Arcturus

@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

Beschriftungen