单词交叉点
let
ListA = {"help me rhonda", "in my room", "good vibrations", "god only knows"},
ListB = {"room", "me", "only"},
intersect=List.Transform(ListA, (lineA)=>Text.Combine(List.Intersect({Text.Split(lineA, " "), ListB}), "|"))
in
intersect
仅标志
let
ListA = {"help me rhonda", "in my room", "good vibrations", "god only knows"},
ListB = {"room", "me", "only"},
contains_word=List.Transform(ListA, (lineA)=>List.MatchesAny(ListB, (wordB)=>Text.Contains(lineA, wordB)))
in
contains_word