Pročitaj na engleskom

Dijelite putem


Table.FindText

Syntax

Table.FindText(table as table, text as text) as table

About

Returns the rows in the table table that contain the text text. If the text is not found, an empty table is returned.

Example 1

Find the rows in the table that contain "Bob".

Usage

Power Query M
Table.FindText(
    Table.FromRecords({
        [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
        [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
        [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
    }),
    "Bob"
)

Output

Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})