All,
I have this output that is combining user email accounts with office email accounts.
I only want to parse the full office emails (OFF1234@email.com)
Is there anyway I can parse the text to only return the full office emails? The office will always have 3 characters and 4 numbers following.
Example 1:
Email@email.com;OFF1234@email.com;Email@email.com
- I only want to parse (OFF1234@email.com)
Example 2:
Email@email.com;OFF4567@email.com;OFF9284@email.com;Email@email.com
- I only want to parse this (OFF4567@email.com;OFF9284@email.com)


Report
All responses (
Answers (