Page 1 of 1

function for extcting the middle part of the field

Posted: Fri Aug 15, 2008 2:25 pm
by kirankota79
which function to use in the transformer to get for example the characters from 16 to 22 in the field of 86 length?

Posted: Fri Aug 15, 2008 2:28 pm
by chulett
The substring operand is square brackets using FieldName[start position, length] notation.

Posted: Fri Aug 15, 2008 5:16 pm
by ray.wurlod
Therefore

Code: Select all

InLink.FieldName[16,7]