Solved: Need help

Syndicate_Admin · ‎10-23-2022

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 · ‎10-23-2022

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

View solution in original post

wdx223_Daniel · ‎10-23-2022

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