Power Query, valide email Adresse aus Text extrahieren

 

neue Abfrage erstellen,

Language M Code

--- SCHNIPP ---

(string as text) as text =>

    Text.Combine(

        List.Select(

            Splitter.SplitTextByAnyDelimiter(

                {" ", ",",";",":"}

            )(string),

            each List.Count(

                Splitter.SplitTextByEachDelimiter(

                    {"@","."}

                )(_)

        )=3 and 

        Text.Length(Text.Select(_, "@"))=1 and

        not Text.Contains(_,"@.")

    ),","

)

---SCHNAPP ---