Need help

[Syndicate_Admin]

Hi Team,

I need help with the coding to separate the Email ID

Input: Chandra Bose S, Subash ; V S, Srijith

Output: [email protected];[email protected]

[wdx223_Daniel · Accepted solution]

= Text.Combine(List.Transform(Text.Split("Chandra Bose S, Subash ; V S, Srijith",";"),each Text.Format("#{1}.#{0}@123.com",List.Transform(Text.Split(_,","),each Text.Replace(Text.Trim(_)," ","-")))),";")