Convert String to Decimal and Error Handling

[abhi90]

Hi All,

I want to convert Data of One of My Column which is holding Value like 7.13084E17. E is nothing but 0's. Value is like 7.13084000000000000.Now I have to Convert it to Decimal. In Output Table Column is in Number(30). Now I am converting it to Decimal Something Like This in variable Port o_row1.column.

Double.parseDouble(row1.column)==0?0ouble.parseDouble(row1.column). Now using this Same in tmap Pass and Fail Table as Var.o_row1.column>=-1.00(Pass) and Var.o_row1.column<=-1.00. But Compilation error is coming saying can't convert from Double to BigDecimal. My Pass Table of tmap o_row1.column is BigDecimal

@rhall, @TRF, @manodwhb, @vboppudi, @TRF

[abhi90]

@vboppudi,

Let me know if any details required. I am also trying

[vboppudi]

Hi Abhi,

Are you looking for this?

Regards,

[abhi90]

@vboppudi,

Yes in Database ValidData should go with E. But how did u managed to do this?

[vboppudi · Accepted solution]

Use the following settings in tMap.

Regards,