yoke(
PREFIX
,
JOINER
,
SUFFIX
)

The yoke( function appends two text items together, with a joiner between them if both are non-blank.


Parameters

This function has three parameters:

prefix – first text item.

joiner – joiner that will be placed between if both prefix and suffix are non-blank.

suffix – second text item.


Description

This function appends two text items (prefix and suffix) together. If both are non-blank, a joiner is placed in between. If either (or both) is blank, the joiner is not used. In some ways this is the reverse of the sandwich( function.

yoke("this"," and ","that") ☞ this and that
yoke("this"," and ","") ☞ this
yoke(""," and ","that") ☞ that
yoke(""," and ","") ☞ 

Note: This function is equivalent to:

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

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.