Skip to main content
Arithmetic Functions
Search
Search Contract Express Help and Support.

This article applies to:

  • Product: Contract Express

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"

Related Content