Use of index function

[JoshGeorge]

It works with data type of Varchar also (Even for your stage variables in this case). Cross check your input seq file and the job design once more.

See if you have passed 'input.file_name' and not 'input.file_type' to stage variable 1.

[sjordery]

I chcked the job again.
In the substring position I tried by giving empty string like
index(input.filename,"",1) and it is returning 1 which is right,but thr indexfunction is not reading the ".".
I also tried by assigning integer value to the stage variables as suggested by ray,but getting the same value 0 as result.

[JoshGeorge]

Put this in the occurance column: index('abcd.txt','.',1) and let know what you are getting in the output for that field

[sjordery]

I deleted the stage variables.
Simply in the derivation stage of occurance column I used the index function like this index(input.filename,".",1) and its working fine.

thnx all