topic Re: Talend Date Parsing lenient in Talend Studio

Talend Date Parsing lenient

Anonymous — Thu, 04 Feb 2016 09:11:11 GMT

Hi,
I have been working on exporting the data from excel input to the MySQL using the TOS 5.6.2. I have been facing the date lenient parsing when I export the date fields. But for CSV files I know the option for strictly checking the dates tFileInputDelimited->Advanced settings->Check date.
I am facing the date lenient for excel files ..if the input date value comes wrong its not rejecting..Please see the below example .. and please assist me on this ..I want to reject the wrong dates..is there any option for excel files..??
Suppose my input file date column format is MM/dd/yyyy

inputdate            Talend output
10/10/2013        2013-10-10
8/29/2013           2013-29-08
13/29/2013         2014-29-01 --->conversion lenient .



Regards,
Raghav

Re: Talend Date Parsing lenient

Anonymous — Fri, 05 Feb 2016 09:29:29 GMT

Hi ..
Can anyone help on this ...??
Thanks-
Raghav

Re: Talend Date Parsing lenient

Anonymous — Fri, 05 Feb 2016 11:43:31 GMT

If you can code:
read everthing as String and do your own check date
If not:
read everything as string write dirctly as CSV and read with you componant which Support checkdate

Re: Talend Date Parsing lenient

Anonymous — Fri, 05 Feb 2016 12:27:13 GMT

Hi.
Thanks for your reply.
I am working with the tfileinputexcel in the Event mode i.e., Less memory consumed for large excel(Event mode). When I try to read the excel file date files it is reading the exact input records.
See the below..

Input Record---> Talend Output
| |
12/13/2015----> 12/13/15
12/18/2015----> 12/18/15
12/4/2015-----> 12/4 /15
Here, Year part is not reading as like as in the input ..it is reading only "YY".
In, Event mode only I am facing this problem. In user mode for small excel files date has been loading the exact values as in the input.

So, is there any options like to check date values strictly in the tfileinputexcel as like check date in the tfileinputdelimited.
And I am not familiar with programing. Please suggest any GUI options.

Thanks-
Raghav.