topic Re: convert string to datetime for csv file in Talend Studio

convert string to datetime for csv file

Anonymous — Sat, 16 Nov 2024 12:05:40 GMT

Hi,
I have a csv file contain string date '12/2/2012 5:47'. I convert to datetime but I got this error Unparseable date: "12/2/2012 5:47"
I try to save the file to excel it work. but for csv it become an error.
Please anyone help me....
Regards,
Ommie

Re: convert string to datetime for csv file

Anonymous — Tue, 05 Mar 2013 05:36:28 GMT

Hi omie,
I have designed a demo job and made a testing for it. The job works well. Could you give us more info, such as your job screenshots and Date pattern so that we can address your issue quickly.
See my job screenshots as follows:
Best regards
Sabrina

Re: convert string to datetime for csv file

Anonymous — Tue, 05 Mar 2013 10:03:29 GMT

Hi Sabrina,
my date data sample is like this:
12/2/2012 0:00
12/2/2012 0:00
12/2/2012 0:00
12/2/2012 0:01
I already try the way what you did but got error :
java.lang.NumberFormatException: For input string: "12/2"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at routines.system.FastDateParser$DateTimeParser.parse(FastDateParser.java:206)
at routines.system.ParserUtils.parseTo_Date(ParserUtils.java:208)
at uc.testdate_0_1.testDate$1RowHelper_tFileInputDelimited_1.valueToConn(testDate.java:992)
at uc.testdate_0_1.testDate.tFileInputDelimited_1Process(testDate.java:1147)
at uc.testdate_0_1.testDate.runJobInTOS(testDate.java:1566)
at uc.testdate_0_1.testDate.main(testDate.java:1434)
Unparseable date: "12/2/2012 0:00"
Do you have any idea? For excel source file it work fine but only for csv file got error for date..
Regards,
Ommie

Re: convert string to datetime for csv file

Anonymous — Tue, 05 Mar 2013 10:30:39 GMT

Hi,
Everything is OK on my version Talend Open Studio for Data Integration(5.2.1r95165). How about checking out the option "Trim all column" in the advance setting of tFileInputDelimited component and make sure that there is no extra space in your "Date pattern"
Best regards
Sabrina