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 ---