topic DATA TYPE CONVERSION in Talend Studio

DATA TYPE CONVERSION

Anonymous — Wed, 26 Sep 2012 05:15:53 GMT

hi,
I am new to Talend and trying to accomplish some intermediate operations in TMAP Component. I need to convert the data types in TMAP to work through my tasks.
I need to convert from String - > Bigdecimal; Integer - > Bigdecimal ; String -> Date
Any help....

Re: DATA TYPE CONVERSION

Anonymous — Wed, 26 Sep 2012 05:55:25 GMT

Hi
1. String-->BigDecimal
new java.math.BigDecimal(row1.columnName)
2. Integer-->BigDecimal
new java.math.BigDecimal(row1.columnName)
3. String-->Date
TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",row1.columnName)
If you want to know more about TalendDate.parseDate(String date_pattern, String string_of_date), go to repository-->code-->System-->TalendDate

Re: DATA TYPE CONVERSION

Anonymous — Thu, 27 Sep 2012 15:30:08 GMT

Hi shong,
Thanks , its removed the error
But in my srouce one patricular column has negative decimal values (-0.05916667)
So in console am getting below message and in job it shows zero rows passed
help pls...