DTS Programming

TrimTrailingWhiteSpace Property

The TrimTrailingWhiteSpace property specifies or returns a value indicating whether trailing white-space characters are removed from the source column string copied by custom transformations.

Applies To

DataPumpTransformMidString Object

DataPumpTransformTrimString Object

Syntax

transerver.TrimTrailingWhiteSpace [= boolean]

Part	Description
transerver	Expression that evaluates to an object from the Applies To list.
boolean	If TRUE, trailing white-space characters are removed from the source string. Default is FALSE.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT TrimTrailingWhiteSpace(VARIANT_BOOL* pRetVal);

HRESULT TrimTrailingWhiteSpace(VARIANT_BOOL pRetVal);

Remarks

White-space characters are spaces, tabs, carriage returns and linefeeds. Trailing white-space characters are those that appear after the last character that is not a white-space character.

The property also can be referenced through the TransformServerProperties collection with the following code:

Set transprops = transform.TransformServerProperties
transprops("TrimTrailingWhiteSpace") [= boolean]