Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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's avatar
    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's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity 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(_)," ","-")))),";")