I have a string which I need to split into email parts i.e:
"Jade, Ex" <Ex.Jade@abc.co.uk>, "Scofield,Michael" (Michael.Scofield@abc.co.uk)" <Michael.Scofield@abc.co.uk>
I managed to split it okay via this:
and got the email parts extracted (two for the time being).
My issue lies if I get further people within the email string as the string can vary and I would need to create more variables to accommodate these. I would like to be able to extract all the email parts within a string like the above and have each email string separated by “;” (e.g. Ex.Jade@abc.co.uk; Michael.Scofieldt@abc.co.uk, etc) and not have to create a variable everytime as I have shown in the image above.
I was thinking of using a regex expression but I am not very familiar with this.
Any help on this matter would be hugely appreciated.