https://community.qlik.com/t5/Talend-Studio/talend-date-issue/m-p/2357000#M122401 <P>Hi bksing,</P> <P>&nbsp;</P> <P>You can use <SPAN>input_column.</SPAN>replaceAll([a-zA-Z],"") and&nbsp;<SPAN>input_column.</SPAN><SPAN>replaceAll("0","") functions to remove string and zero value from source.</SPAN></P> <P><SPAN>After that use TalendDate.parseDate("dd-MM-yyyy",input_column) to parse date.</SPAN></P> Tue, 10 Apr 2018 08:21:34 GMT Anonymous 2018-04-10T08:21:34Z https://community.qlik.com/t5/Talend-Studio/talend-date-issue/m-p/2356999#M122400 <P>dear sir</P> <P>i have a excel sheet column name test date.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dateQues.JPG" style="width: 190px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LtOk.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146256iAF64B45F4B43D7D9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LtOk.jpg" alt="0683p000009LtOk.jpg" /></span></SPAN></P> <P>how can i set it into a standard method. am facing problem because it contain string also and integer value 0.&nbsp;</P> <P>how can string and integer value 0&nbsp; replace into null.&nbsp;</P> <P>i hope u understand my trouble. Kindly resolve my issue.</P> Tue, 10 Apr 2018 07:12:02 GMT https://community.qlik.com/t5/Talend-Studio/talend-date-issue/m-p/2356999#M122400 Anonymous 2018-04-10T07:12:02Z https://community.qlik.com/t5/Talend-Studio/talend-date-issue/m-p/2357000#M122401 <P>Hi bksing,</P> <P>&nbsp;</P> <P>You can use <SPAN>input_column.</SPAN>replaceAll([a-zA-Z],"") and&nbsp;<SPAN>input_column.</SPAN><SPAN>replaceAll("0","") functions to remove string and zero value from source.</SPAN></P> <P><SPAN>After that use TalendDate.parseDate("dd-MM-yyyy",input_column) to parse date.</SPAN></P> Tue, 10 Apr 2018 08:21:34 GMT https://community.qlik.com/t5/Talend-Studio/talend-date-issue/m-p/2357000#M122401 Anonymous 2018-04-10T08:21:34Z