Substring Issue
Posted: Thu Nov 08, 2007 6:12 am
Hi,
In the Transformation derivation
I taken SourceAccountId[9, 14] derivation.
Input data is '123456789ABCDFGHIJKLMNOP'
I am getting the out put as 9ABCDFGH
Is datastage counts the position of the character from 0 to or 1
Even if the datastage counts the position from 0 it should give the output data as
ABCDFG
Then why Iam getting the different ouput?
Can any body tell how exactly it's working?
In the Transformation derivation
I taken SourceAccountId[9, 14] derivation.
Input data is '123456789ABCDFGHIJKLMNOP'
I am getting the out put as 9ABCDFGH
Is datastage counts the position of the character from 0 to or 1
Even if the datastage counts the position from 0 it should give the output data as
ABCDFG
Then why Iam getting the different ouput?
Can any body tell how exactly it's working?