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]