Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

Arithmetic Functions

Dot Operator

Description 1 of 2 (Select a list of text values from a lookup table):

Find a list of text values in a named column of a lookup table.
The lookup table used is the first which has both the
return column
 and a
find column
 containing all the members of the given list or which contains an empty cell. Note that the
find column
 will be different from the
return column
.
The function returns a cell text in the
return column
 for every member of the given list. If the member occurs in a cell of the
find column
 then the return text is the corresponding cell of the
return column
 for that row of the lookup table. Otherwise, it is the corresponding cell in the
return column
 for an empty cell in the
find column
.
note
LOOKUP TABLE ORDER
The order of lookup tables is the order by which they are arranged in the template document using the DB Author Lookup Editor. For templates which include/attach sub-templates the overall order is determined by the order in which the sub-templates are included/attached.
Returns:
Text*
Parameters:
Parameter
Data Type
Description
1
Any*
The given list of texts.
2
Any
The name of the return column.
Example:
When using functions inside a field, remember the field brackets:
{ServicesIncluded.Cost}
Expression
Result
List( "England", "Japan", "USA" ).Capital
where a lookup table contains countries and their capitals
List( "London", "Tokyo", "Washington" )
List( "US of A" ).Capital
where a lookup table contains an empty cell in the countries column with the text
Unknown Capital City
 in the corresponding cell of the capitals column
List( "Unknown Capital City" )

Description 2 of 2 (Select a text value from a lookup table):

Find a text value in a named column of a lookup table.
The lookup table used is the first which has both the
return column
 and a
find column
 containing the given text or which contains an empty cell. Note that the
find column
 will be different from the
return column
.
If the given text occurs in a cell of the
find column
 then the return text is the corresponding cell of the
return column
 for that row of the lookup table. Otherwise, it is the corresponding cell in the
return column
 for an empty cell in the
find column
.
note
LOOKUP TABLE ORDER
The order of lookup tables is the order by which they are arranged in the template document using the DB Author Lookup Editor. For templates which include/attach sub-templates the overall order is determined by the order in which the sub-templates are included/attached.
Returns:
Text
Parameters:
Parameter
Data Type
Description
1
Any
The given text.
2
Any
The name of the return column.
Example:
When using functions inside a field, remember the field brackets:
{ClientName.Address}
Expression
Result
"England".Capital
where a lookup table contains countries and their capitals
"London"
"US of A".Capital
where a lookup table contains an empty cell in the countries column with the text
Unknown Capital City
 in the corresponding cell of the capitals column
"Unknown Capital City"

This article applies to:

  • Product: Contract Express

Related Content