Table.FindText
Keeps the rows where some cell has the text you look for in it.
Group: Table. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Table.FindText(table as table, text as text) as table| Parameter | Type | Description |
|---|---|---|
table | table | The table to search. |
text | text | The text to look for, anywhere in a cell. |
Returns
table. The rows with a match, in their order, with all of their columns.
Examples
Rows that mention Oslo
let
Orders = #table({"Order", "Shop", "Note"}, {
{1, "Oslo", "Delivered"}, {2, "Bergen", "Send via Oslo"}, {3, "Bergen", "Picked up"}})
in
Table.FindText(Orders, "Oslo")| Order | Shop | Note |
|---|---|---|
| 1 | Oslo | Delivered |
| 2 | Bergen | Send via Oslo |