i have a excel sheet column name test date.
how can i set it into a standard method. am facing problem because it contain string also and integer value 0.
how can string and integer value 0 replace into null.
i hope u understand my trouble. Kindly resolve my issue.
You can use input_column.replaceAll([a-zA-Z],"") and input_column.replaceAll("0","") functions to remove string and zero value from source.
After that use TalendDate.parseDate("dd-MM-yyyy",input_column) to parse date.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables