|
Multiple LINKED Functions |
  
|
|
Multiple LINKED Functions |
|
You may need to "link" Functions together (with a CONCATENATION) so as to apply the result of the current Function to the previous result
ie : capitalize the LASTNAME and append (with a space separator) the value of FIRSTNAME
(this example comes from a multiple linked condition "set") where we have 3 linked conditions IF xxxx ELSIF xxxx ELSIF xxxx
this is why you can see 3 times CAP(italize) LASTNAME depending on the condition that "parent" Function is linked to
These linked functions can be used in conjunction with multiple linked conditions or with simple conditions or again alone (not linked to any condition)
When you use these linked Functions the FIRST Function is considered as the PARENT one and the linked ones as CHILD ones
This is a linked to Condition PARENT function example
This is a linked to Condition CHILD function example
To LINK 2 Functions :
1. Click on "Apply to previous Result" (this will unhide for you the CONCAT options)
2. fill in the type of separator you wish to use
If you want a space separator then type in 'space' (this is the only time when it is needed to 'write' space)
SPECIAL LINKED CONCATENATIONS :
space () (WITHOUT the word space but with a keyboard space)
()
space [] (WITHOUT the word space but with a keyboard space)
[]
if you select one of these then the resulting value will be placed WITHIN the BRACKETS ie : Pompano Beach (FL)
The ORDER in which you add your Functions is of course followed during runtime processing
The example given (first picture) is based on these conditions :
(1) IF FIRSTNAME is EMPTY
(2) ELSIF FIRSTNAME not EMPTY and MIDDLENAME is EMPTY
(3) ELSIF FIRSTNAME not EMPTY and MIDDLENAME not EMPTY
The linked Functions are :
(1) CAPITALIZE LASTNAME
(2) CAPITALIZE LASTNAME
(2) + linked with ' ,' CAPITALIZE FIRSTNAME
(3) CAPITALIZE LASTNAME
(3) + linked with ' ,' CAPITALIZE FIRSTNAME
(3) + linked with 'space' EQUAL MIDDLEINT
(3) + linked with '' (no separator defined) a DEFAULT of ''. (period)
The RESULT is as such :
(1) Last Name
(2) Last Name ,First Name
(3) Last Name ,First Name T.