Forum Discussion
Solved
How to remove multiple email addresses
Hello. A field (emailBody) contains the body/text of certain emails we have received. In Power Query, I need to remove/obscure email addresses for data protection reasons. One entry can cont...
cannellonigreyh You can use this:
AddedCustom = Table.AddColumn ( PreviousStep, "New Text", each Text.Combine ( List.Select ( Text.Split ( [Text], " " ), each not Text.Contains ( _, "@" ) ), " " ), type text )
Input:
Row 1: Hi my name is Tom and my email address is [email protected] I would like to discuss the price of brake fluid.
Row 2: My brother's email address is [email protected] and mine is [email protected] and I am very happy because biscuits exist.
Output:
Row 1: Hi my name is Tom and my email address is I would like to discuss the price of brake fluid.
Row 2: My brother's email address is and mine is and I am very happy because biscuits exist.
cannellonigreyh You can use this:
AddedCustom =
Table.AddColumn (
PreviousStep,
"New Text",
each
Text.Combine (
List.Select (
Text.Split ( [Text], " " ),
each not Text.Contains ( _, "@" )
),
" "
),
type text
)