CharacterStart Property
From DTS Programming
CharacterStart Property
The CharacterStart property specifies or returns the starting position of the substring of the source column to be copied by custom transformations.
Applies To
| DataPumpTransformMidString Object |
Syntax
object.CharacterStart [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to a DataPumpTransformMidString object |
| value | Position of the starting character of the substring to be copied |
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT CharacterStart(long* pRetVal);
HRESULT CharacterStart(long pRetVal);
Remarks
If the substring starts at the first character of the source column, the property has the value of 1. If a value less than 1 is provided, 1 is used. If a value greater than the number of characters in the source string is provided, a zero-length string is copied.
The property also can be referenced through the TransformServerProperties collection with the following code:
Set transprops = transform.TransformServerProperties
transprops("CharacterStart") [= value]