Forum Discussion
Solved
How do i delete rows with text
Hi, In colum1 I want to delete rows with text 'Ending Balance for Period' and 'GL JE Name' how would I do this? Many thanks
Just filter them out. The logic here is you won't technically be removing them, but you'll be selecting all rows that don't have that text.
- On the column where this text appears, click the filter icon dropdown next to the column name and select Text Filters, then Does Not Contain
- Fill in the dialog box as shown below.
It will generate code similar to this:
=Table.SelectRows(#"Changed Type", each not Text.Contains([ID], "Ending Balance for Period") and not Text.Contains([ID], "GL JE Name"))
Just filter them out. The logic here is you won't technically be removing them, but you'll be selecting all rows that don't have that text.
- On the column where this text appears, click the filter icon dropdown next to the column name and select Text Filters, then Does Not Contain
- Fill in the dialog box as shown below.
It will generate code similar to this:
=Table.SelectRows(#"Changed Type", each not Text.Contains([ID], "Ending Balance for Period") and not Text.Contains([ID], "GL JE Name"))
Thank you again for the support