Simple query

[arnie_nits]

hi,

I have a varchar field of lenght 11 and I need to find the characters from 6th to 9th position, in transformer stage.Plz help.

Regards
Arnab.

[us1aslam1us]

check string() and substring() functions.simple case will be string[6,4].

[vmcburney]

In the Modify Stage you use the substring function, in the Transformer stage you treat the field as an array and simply used inputfieldname[6,4] as shown by Arnab. You can also check the length of the field first if it's not always 11 characters.

[ray.wurlod]

In the Modify stage, however, counting is zero-based, so you will need to retrieve four characters beginning from position 5.