Forum Discussion

andy421's avatar
andy421
Frequent Visitor
2 years ago
Solved

Removing duplicate values from a single row

I have an email column which has data like   email [email protected] [email protected] [email protected],[email protected],[email protected] [email protected] [email protected],[email protected]   I need to keep only 1 email in the row  ...
Need Help
  • jennratten's avatar
    jennratten
    2 years ago

    Hello - you can get the expected result by extracting the text before the comma, like this:

    Table.TransformColumns(#"Changed Type", {{"Column1", each Text.BeforeDelimiter(_, ","), type text}})

    Result

     

jennratten's avatar
jennratten
Icon for Super User rankSuper User
2 years ago

Hello - you can get the expected result by extracting the text before the comma, like this:

Table.TransformColumns(#"Changed Type", {{"Column1", each Text.BeforeDelimiter(_, ","), type text}})

Result