DSXchange

I am Taking Data from flatfile and loading to sequentual file. In flat file it is just a single column which I am dividing into many columns based on requirment. In one case i have to pick data from 21st to 25th char of source file and have to save it as decimal in target.
For Example, the data is '+2014' i need to store it as decimal. So I created a Decimal column and saved 21st to 25th char of source file in that column. but the data is getting saved as '00000.' instead of '2014.' or '02014.'.

Please help me. Please let me know what am I doing wrong here?

Show us the expression you used to extract the five characters.

I suspect that you have used an incorrect syntax.

I have created a decimal column in transformer output and gave the following expression...

Table_Read.Source_Col[21,25]

Use StringToDecimal function in the transformer. It could be the case that the substring is being treated as character.
StringToDecimal(Table_Read.Source_Col[21,25])

Right. Use explicit transformations, don't just take strings and shove them into other datatypes.

The second argument is length, not finishing position. Try:

Got distracted and forgot to note that. D'oh.

Thank you for noticing it. I am new to DataStage so i am still confused about the syntax. Thank you all. I corrected the syntax and that fixed the issue and for safe side i used explicit transformation too.