DSXchange

Hi,

I'm reading from fixed width file.
in that i have a amount column starts with + or -

i.e -10.00
-12.12
+14.98
+25.78

im reading the file as squential mode.
i want to sum the column + seperately and - values seperately.

and finally differences for + values and -Values.
how can i acheive this.

Convert to Decimal first and then use an aggregator stage to calculate the sum. Even if the order is sequential, it should give you correct sum irrespective of the sign.
-10+5 is always going to be -5.

From source itself im getting as decimal value.
how can i convert.
please suggest me.

If your source already have it as decimal then what is stopping you to use aggregator for Summing those values??

if it's decimal in source, then there is no need of any type conversion. Use an aggregator stage to perform regular summation.