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!
@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
Is it always 2 columns? you can use this regex for it
<(.+)> <(.+)>
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |