Forum Discussion

atpbi10's avatar
atpbi10
Helper 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

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

If the string to be deleted is at the end of the text (or better,if the text to keep is before the PLxyz pattern ), as in your examples, you can create a custom column in this way.

You could eventually change "PL" with " PL" to trim the trailing space