Start 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