Home Search

DriveWorks Pro 22

Send Feedback


Filters the table on the supplied list of values.


TableFilterByList([Table],[Column Index],[Filter List],[Include])


Table is the table to filter.

Column Index is the index of the column on which to search, starting at 1 for the first column.

Filter List is a Pipebar(|) delimited list of text.

Include is TRUE to include all results matched in the filter, FALSE will exclude results matched in the filter.


TableFilterByList(DwLookupCustomers,5,"USA|United Kingdom",TRUE){"FirstName","SecondName","Company","City","Country";"Jeff","Beach","Stromann Roofing LLC","Columbus","USA";"Thomas","Jackson","King LLC","San Francisco",""USA";"Sam","Jones","Cork & Sons","Cardiff","United Kingdom";"Martin","Biddiss","Howell West Ltd","London","United Kingdom";"Patrick","Dishman","Harber and Dietrich","Charlotte","USA";"Ivett","Oaks","Cartman Group","Dumfries","United Kingdom"}The returned array is a new table containing only results that match with the items specified in the filter list for the specified column.

Example Data

This is the Customers table that will be filtered to match the filter list.

JeffBeachStromann Roofing LLCColumbusUSA
ThomasJacksonKing LLCSan FranciscoUSA
SamJonesCork & SonsCardiffUnited Kingdom
JulietteDoboisMarquardt PourosLyonFrance
IsabellaWemBayer WelchVelbertGermany
MartinBiddissHowell West LtdLondonUnited Kingdom
FreddieMilletonHill LtdTorontoCanada
PatrickDishmanHarber and DietrichCharlotteUSA
IvettOaksCartman GroupDumfriesUnited Kingdom
TobeHellyarSchneider ManzBerlinGermany