Table.FindText

Sintaksis

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

Tentang

Mengembalikan baris dalam tabel table yang berisi teks text. Jika teks tidak ditemukan, tabel kosong dikembalikan.

Example

Temukan baris dalam tabel yang berisi "Bob".

Penggunaan

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"]})