I have no idea how to do this, i have used the Slpit method but that did not work well, my issue is , i am doing a read on an sql databse and my strings are being returned as the following 3 ways

firstname Lastname ([email protected])
firstname Lastname ([email protected]);firstname Lastname ([email protected])
[email protected];[email protected];[email protected]

Some have 1 to 8 email addresses per- line, and i need to run a task on each extracted email address, if i can atleast get posted in the right direction on methods to research, or sample codes, would be great.