talend date issue

[Anonymous]

dear sir

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.

[Anonymous]

Hi bksing,

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.