Saving A User Formula

Complex formulas that are created in the formula builder can be saved under a user-defined name for use when configuring future DTS files. Once a formula is saved, it is included in the Function Browser under User Defined Formula.

To save a formula

  1. Click Formula. The Edit Formula dialog box appears.
  2. Click the Save User Formula button. The User Defined Formula dialog box appears.
  3. In Name, enter a name for the formula.
  4. In Example, enter an example of using this formula.
  5. In Default, enter a default value for the formula.

    Use %s, with a lower-case s, to set a location in the formula where existing text from the formula pane is to be inserted when you double-click the user-defined formula name in the function browser.

  6. In Help Text, enter text to display as help for using the formula.
  7. Click OK. The formula is added to the Function Browser.

Note: The name that you give a new formula displays in the Function Browser.

Example

Name firstname
Example: PROPER(PARSENAME(SourceField,"F"))
Default: PROPER(PARSENAME(%s,"F"))

See also

Creating Fixed Value Links

Creating Custom Functions

Operators and Functions

Using Formulas

Modifying your Source configuration

Data Limitations