Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
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'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(_)," ","-")))),";")

1 Reply

  • wdx223_Daniel's avatar
    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(_)," ","-")))),";")