Seven Stars

talend date issue

dear sir

i have a excel sheet column name test date.

dateQues.JPG

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.

1 REPLY
Seven Stars

Re: talend date issue

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.

Thanks & Regards
A Ravi Kumar
Mobile Number : +91 852-762-1083
Email-id : a.ravikumar104@gmail.com
Skype Id : ammanannaravikumar