List.FindText

About

Searches a list of values, including record fields, for a text value.

Syntax

List.FindText(list as list, text as text) as list  

Arguments

Argument Description
list The List to search.
text The value to search for.

Example

List.FindText(  
  
{  
  
    [field1 = "t1", field2 = "t2" ],  
  
    [field1 = "test1", field2 = "test2" ],  
  
    [field1 = "another test", field2 = 5 ],  
  
    [field1 = 1, field2 = 2 ]  
  
}, "test")  
  
equals  
  
{  
  
    [field1 = "test1", field2 = "test2" ],  
  
    [field1 = "another test", field2 = 5 ]  
  
}  
  
List.FindText(  
  
{  
  
    [ Field1 = "hello", Field2 = "world" ],  
  
    [ Field1 = "hello1", Field2 = "hello2" ],  
  
    [ Field1 = "another test", Field2 = 5 ],  
  
    [ Field1 = 1, Field2 = 2 ]  
  
}, "hello")  
  
equals  
  
{  
  
    [Field1="hello", Field2 = "world"],  
  
    [Field1 = "hello1", Field2 = "hello2"]  
  
}