connect(
PREFIX
,
CONNECTOR
,
SUFFIX
)

The connect( function appends a prefix and suffix together with a connector in between.


Parameters

This function has three parameters:

prefix – word or phrase to be used as a prefix

connector – text to be used in between the prefix and suffix if both are present.

suffix – word or phrase to be used as a suffix


Description

This function appends a prefix and suffix together with a connector in between. If either the prefix or the suffix is missing, the connector will also be left out. For example, connect(City,", ",State) combines the city and state with a comma and space in between, but if either the city or state is missing then the comma and space will also be left out.

connect("Fullerton",", ","CA") ☞ Fullerton, CA
connect("Fullerton",", ","") ☞ Fullerton
connect("",", ","CA") ☞ CA

The sandwich( function performs a similar operation.

Note: This function is equivalent to:

?(prefix<>"" and suffix<>"",prefix+connector+suffix,prefix+suffix)

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.