Forum Discussion

atpbi10's avatar
atpbi10
Icon for Helper I rankHelper I
5 years ago
Solved

Remove certain string from text in the column

Hey! How can I transform this column which contains certain string that starts with certain character which is in my case "PL"   Name Jay Chua PL231221 John Cena Arnold Black PL212233 ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can add a custom column with this formula

     

    = Text.Combine(List.Select(Text.Split([Name], " "), each not(Text.Contains(_, "PL"))), " ")

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can add a custom column with this formula

 

= Text.Combine(List.Select(Text.Split([Name], " "), each not(Text.Contains(_, "PL"))), " ")

 

Pat