The List file is a text file and is of the format:
literal1
literal2
literal3
...
literaln
For example, a list of cities might look like the following:
chicago
miami
cleveland
boston
new york
washington
Where the text line contains multiple words (“new york”) then the literal string "new york" must exist in the file, ignoring case, so "new jersey yorktown" would not be a match. Nor would "york new". If you would like multiple words on a line to be searched for independently, then the first line in the text file should contain a solo asterisk (*):
*
chicago
miami
cleveland
boston
new york
washington
The solo asterisk on the first line will cause the string “new york” to be searched for as “new” and “york” so that "new jersey yorktown" would now be considered a match. Both values “new” and “york” must be found concurrently in the record or specified fields for the LISTFIND() function to a return a true value.