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: subash.chandra-bose-s@1231221.com;srijith.v-s@1212111.com

[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(_)," ","-")))),";")