Forum Discussion
Helper IIDeleting row where column contains text
Hi nunnc01
Assume you have table
Format->Trim (Returns the result of removing all leading and trailing whitespace from text value
text.Change type to whole number
Replace error with null
Finally, remove null.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IHi, I have some rows where I want to remove the rows contatining some text values,
example- I have rows with texts like "frieght", "reels", and I want to remove those rows automatically, Column type is "text", I only want to remove the rows which contains these texts
Does anyone know how to do this
- Nathaniel_C
Community Champion
Hi Anupa_Jayakody
Easy go to Power Query click on the down arrow in the header of the column you wish to filter. Click on those you wish to delete, and like magic, gone. The nice thing is that you will see a filter icon when it is done. You can also remove this step, or modifiy it by either clicking on X by the step or the gear icon.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel- Anupa_Jayakody
Thank you, but I want this to be performed every time when I add a new file, so I dont have to do this manually, and the filter should pick lines only without those specified words in the column
For example- I want to remove any row that contains "XYS" text anywhere in the cells in that column. It could be even text "XYS" is with some other words too, but need to be removed if it is there in that column
