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.

Is this type of Regex even possible?

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
MarqueeCrew
20 - Arcturus
20 - Arcturus

@miglema ,

 

 if you use multiple formulas, can you envision 

 

replace([Stuff],"<>", '|')

 

 and then

 

 replacechar([stuff],"<>", '')

 

 you would then have a set of pipe delimited pairs of name |value. 

you could use a text to columns tool easily. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
SPetrie
13 - Pulsar

Is it always 2 columns? you can use this regex for it

 <(.+)> <(.+)>

SPetrie_0-1651091577466.png

 

Labels
Top Solution Authors