Home Search

DriveWorks Pro 21
SppFilterTableByInclusionList

Send Feedback

SppFilterTableByInclusionList

This is now an inbuilt function, please see TableFilterByList for more information.

Returns a table with data included based on a pipe bar delimited inclusion string

Syntax

SppFilterTableByInclusionList([Table Array],[Column],[Inclusion List],[IncludeHeader])

Where:

Table Array is a Table array (such as the data in a standard table, or the result of a QueryDataValues function).

Column is the column on which to search for inclusions Number starting at 1 for the first column.

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

IncludeHeader is TRUE to include header values in the returned table.

Example

RuleResultMeaning
SppFilterTableByInclusionList(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 inclusion list for the specified column.

Example Data

This is the table that will be filtered to only show data that matches the inclusion list.

FirstNameSecondNameCompanyCityCountry
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