topic Re: String to date Conversion in Talend Studio

String to date Conversion

Anonymous — Sat, 16 Nov 2024 10:43:52 GMT

I'm new to Talend. Can anyone help me in converting String(20150901) to Date(2015-09-01).
Thanks in Advance

Re: String to date Conversion

Anonymous — Tue, 22 Mar 2016 15:24:30 GMT

Hello kalkavi,
If you want to change the String to Date, you can use TalendDate.parseDate("yyyyMMdd", yourdate).

Lin LIN
Consultant BI/Talend
Synaltic Group

Re: String to date Conversion

Anonymous — Tue, 22 Mar 2016 15:58:24 GMT

Thanks louislinlin
Please find the following error. I have also pasted the screen shot. Thanks for your help.
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif]Exception in component tMap_1[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif]java.lang.RuntimeException: java.text.ParseException: Unparseable date: ""[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] at routines.TalendDate.parseDate(TalendDate.java:895)[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] at routines.TalendDate.parseDate(TalendDate.java:839)[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] at local_project.testjob_0_1.TestJob.tFileInputFullRow_1Process(TestJob.java:1231)[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] at local_project.testjob_0_1.TestJob.runJobInTOS(TestJob.java:1618)[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] at local_project.testjob_0_1.TestJob.main(TestJob.java:1475)[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif]Caused by: java.text.ParseException: Unparseable date: ""[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] at java.text.DateFormat.parse(Unknown Source)[/font][/color]

[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] at routines.TalendDate.parseDate(TalendDate.java:881)[/font][/color]

Re: String to date Conversion

Anonymous — Tue, 22 Mar 2016 16:10:32 GMT

kalkavi,
You should change to yourdate == null || "".equals(yourdate.trim()) ? null : TalendDate.parseDate("yyyyMMdd", yourdate)

Lin LIN
Consultant BI/Talend
Synaltic Group

Re: String to date Conversion

Anonymous — Tue, 22 Mar 2016 16:49:42 GMT

Thanks louislinlin for your help. It works fine.
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif]Also, on another topic. Is there a function to convert String to Long. do i have to post as a seperate topic.?[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif]Any help would be appreciated.[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif]Thanks[/font][/color]

Re: String to date Conversion

Anonymous — Tue, 22 Mar 2016 16:55:45 GMT

kalkavi,
There is the founction Long.parseLong(yourString) in Java. So you can do the same thing : yourString == null || "".equals(yourString.trim()) ? null : Long.parseLong(yourString)

Lin LIN
Consultant BI/Talend
Synaltic Group

Re: String to date Conversion

Anonymous — Tue, 22 Mar 2016 17:01:01 GMT

hi,
I personally use :

Long myLong = Long.valueOf(<your string here>);

If your string is not a number he will throws a NumberFormatException.

CSen

Re: String to date Conversion

Anonymous — Tue, 22 Mar 2016 23:35:54 GMT

Thanks louislinlin & csen