Forum Discussion
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 ...
You can add a custom column with this formula
= Text.Combine(List.Select(Text.Split([Name], " "), each not(Text.Contains(_, "PL"))), " ")
Pat
You can add a custom column with this formula
= Text.Combine(List.Select(Text.Split([Name], " "), each not(Text.Contains(_, "PL"))), " ")
Pat
Hey thanks for the solution, works properly. Just wanted to make sure if this is case sensitive? Like for the table in the example if I have guy named "Max Planck", he wont have his surname removed?