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
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.
Note: The name that you give a new formula displays in the Function Browser.
Name | firstname |
---|---|
Example: | PROPER(PARSENAME(SourceField,"F"))
|
Default: | PROPER(PARSENAME(%s,"F"))
|
See also
Modifying your Source configuration