Table.FindText

About

Returns a table containing only the rows that have the specified text within one of their cells or any part thereof.

Syntax

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

Arguments

Argument Description
table The Table to modify.
text The text to compare against.

Example

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")  
CustomerID Name Phone
1 Bob 123-4567