Finding Literals Within a Field or Fields

Use LISTFIND() to search for a list of literal strings within one or more field(s) (whether numeric, character or date).

To search for a single list of cities in either the CITY or DESCRIPTION fields, enter the following condition in a command or as a View filter:

LISTFIND("c:\data\list.txt",CITY,DESCRIPTION)

Note: Quotes are required around the list file path and name.

LISTFIND() only returns true if the search value is found in either the CITY or DESCRIPTION fields.

To search for cities contained within multiple lists in either the CITY or DESCRIPTION fields, enter the following condition in a command or as a View filter:

LISTFIND("c:\data\list1.txt,c:\data\list2.txt",CITY,DESCRIPTION)

Note: Commas are used to separate multiple list files within the quotes. There must not be any spaces before or after the commas.