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]