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