Thursday, 18 September 2014

Tip : Converting String to BigDecimal and in tMap column expression of Talend ETL

The below expression in tMap column editor for a particular column will convert string to BigDecimal and replace the "?" mark with empty space .

new BigDecimal(StringHandling.CHANGE("12345?","\\?",""))


:-)