TrimLeadingWhiteSpace Property
The TrimLeadingWhiteSpace property specifies or returns a value indicating whether leading white-space characters are removed from the source column string copied by custom transformations.
Applies To
| DataPumpTransformMidString Object | DataPumpTransformTrimString Object |
Syntax
transerver.TrimLeadingWhiteSpace [= boolean]
| Part | Description |
|---|---|
| transerver | Expression that evaluates to an object from the Applies To list. |
| boolean | If TRUE, leading white-space characters are removed from the source string. Default is FALSE. |
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT TrimLeadingWhiteSpace(VARIANT_BOOL* pRetVal);
HRESULT TrimLeadingWhiteSpace(VARIANT_BOOL pRetVal);
Remarks
White-space characters are spaces, tabs, carriage returns and linefeeds. Leading white-space characters are those that appear ahead of the first 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("TrimLeadingWhiteSpace") [= boolean]