How to convert String to Bigdecimal

[Anonymous]

Hi All,

How can I convert string to bigdecimal in Tmap.I am reading text file from tfileinputdeilimited where data is tagged with doublequotes i.e "8976.3546" .Thus I am reading this data as tring in tfileinputdelimited then trying to convert into bigdecimal in tmap component.Once conversion is done in tmap .bigdecimal data will be inserted into target tables through toracleinput component.Below is screenshot for your reference.

Please assist on this issue asap.

 

Thamks.

Regards,

Vivek

[vapukov · Accepted solution]

Hi Vivek

try use this

new BigDecimal(row1.string_column)

 

[Anonymous]

Thanks,That worked...