Things learned other than Pentaho
28 Jan 2014 CREATE DATABASE LINK (Oracle) Sample query select A.column1 from TABLEA A where not exists (select 1 from TABLEA, schemaX.TABLEZ Z where A.Column1=Z.Column2) JAVA SCRIPT Example var str = " Hyderabad "; var result= str.substr(1,4) So result is yder Format str.substr(Index Number,# of characters from Index) -- CHECK FOR NUMERIC DATA replace( translate( rtrim(ltrim(FIELD_NAME)), '.0123456789', '00000000000' ), '0', '' ) is null condition will identify the data (numeric data only) replace( translate( rtrim(ltrim(FIELD_NAME)), '.0123456789', '00000000000' ), '0', '' ) is not null condition will identify the data (contains non-numeric data) that require cleansing.