Regex in characters

Question

Hello, I have a set of data from Outlook inbox where specific answers are separated by <> characters, for example: <99999999> <+3700000000> 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!

Qiu · Answer

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

https://regex101.com/

0428-miglema.yxmd

IraWatt · Answer

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 :)

All the best,

Ira

regex.yxmd