Pages

Thursday, March 7, 2013

Talend - String to float conversion using tMap component

String to float conversion in talend using tMap component

Relational.ISNULL(ExceltoMap.PlannedEffort)? null:((ExceltoMap.PlannedEffort).matches("[0-9]*\\.?[0-9]+")?Float.parseFloat(ExceltoMap.PlannedEffort):null)

ExceltoMap.PlannedEffort - Component variable

Not: this expression should allow only integers and floating point numbers

1 comment: