How to convert String to Bigdecimal

Six 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

 

 

 

 

 

 

 


Accepted Solutions
Thirteen 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 

-----------

All Replies
Thirteen 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 

-----------
Six Stars

Re: How to convert String to Bigdecimal

Thanks,That worked...

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.