Forum Discussion

Administrator

3 years ago

Solved

Need help

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
3 years ago
= 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(_)," ","-")))),";")

wdx223_Daniel

Community Champion

3 years ago

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