DTS Programming

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]