Four Stars

How to convert String to Bigdecimal

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.

 

 Capture.PNG

 

 

Thamks.

 

Regards,

Vivek

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Ten Stars

Re: How to convert String to Bigdecimal

Hi Vivek

 

try use this

new BigDecimal(row1.string_column)

Screen Shot 2017-05-11 at 8.59.01 PM.png 

-----------
2 REPLIES
Ten Stars

Re: How to convert String to Bigdecimal

Hi Vivek

 

try use this

new BigDecimal(row1.string_column)

Screen Shot 2017-05-11 at 8.59.01 PM.png 

-----------
Four Stars

Re: How to convert String to Bigdecimal

Thanks,That worked...