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)
I believe this question has been answered at https://powerusers.microsoft.com/t5/Building-Flows/Parse-Output-by-number-of-characters/m-p/2266649#M251759
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional