DTS Programming

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]