Add a Macro Function
- On the Macro Function Library window, enter the name for the new macro function in the USR box.
You can include an underscore in the name, but none of the following special characters:
! ' " # $ % & ( ) * + , - . / \ : ; < > = ? @ [ ] ^ ` { } | ~
- If applicable, fill in the Comments box.
- In the Function Body window, enter the expression or enter it through the following selections:
- Double-click the applicable item(s) in the Functions and Macro Functions lists.
- To quickly find and select a picklist, enter "PICK: to display the Pick List window.
- To display an list of options that you can select, enter the applicable IntelliSense characters.
- To replace all instances of a field, variable, or function in the condition with another field, variable, or function, you can use the Find and Replace feature.
- Select the applicable operator buttons.
Your selections are added to the Function Body window. The syntax is color-coded as follows:
- Literal (fixed value) - Blue
- Operators - Gray
- & and I - Red
- Functions - Green
- String Functions - Aqua
- Edit the expression using the Cut, Copy, Paste, Undo, and Redo buttons and insert a carriage return to start a new line.
You also can clear all your entries to start again.
- To cut or copy text, highlight it, and select Cut or Copy.
To paste cut or copied text, position your cursor where you want to paste the text, and select Past.
- Select Undo or select CTRL+Z to reverse your preceding action; select Redo or select CTRL+Y to restore the action.
You can undo/redo your actions up to 11 times. You can also select DELETE to delete all or part of the calculation.
- To start a new line, select CTRL+ENTER.
- To clear the expression, select Clear.
- In the Parameter box, enter each parameter.
Note: The parameters appear in the Function window.
- To add a new parameter, enter the name in the text box, and then select Add.
The parameter is listed beneath the text box.
- To update an existing parameter, select it in the Parameter list to fill in the text box, enter your changes, and then select Update.
- To delete an existing parameter, select it in the Parameter list, and then select Delete.
- To clear all parameters, select Clear.
- To add a new parameter, enter the name in the text box, and then select Add.
- To add the new macro function to the Library window, select Add to the right of the Function Body.
- To add another macro function, repeat the preceding steps.
- To generate a list of current macro functions in a log file, enter the full file path in the Log to File box.
- Select OK.