topic Re: String to date conversion in Talend Studio

String to date conversion

Anonymous — Thu, 05 Apr 2018 18:14:53 GMT

Hi,

So, I've source string in the format 'MMddyyyy'("12012016") and I want to convert it into date 'MM-dd-yyyy'.

Is there a function in talend to convert this type? I used TalendDate.parseDate("MM-dd-yyyy",source.column) and its throwing-- Unparseable date: "12012016" error.

Any suggestions?

Thanks in advance

Re: String to date conversion

Anonymous — Thu, 05 Apr 2018 18:25:31 GMT

You can simply add "-" to each of the necessary positions.

Re: String to date conversion

Anonymous — Thu, 05 Apr 2018 18:27:20 GMT

In that scenario, the output will be still a string type not date, isn't it?

Re: String to date conversion

Anonymous — Thu, 05 Apr 2018 18:27:34 GMT

TalendDate.formatDate("MM-dd-yyyy", TalendDate.parseDate("MMddyyyy",yourDate))

That is what you want.

Re: String to date conversion

Anonymous — Thu, 05 Apr 2018 18:33:18 GMT

It is all string manipulation. You can also do something like the below:

yourDate.substring(0,2) + "-" + yourDate.substring(2,2) + "-" + yourDate.substring(4,4)

Re: String to date conversion

Anonymous — Thu, 05 Apr 2018 18:53:57 GMT

Thankyou!

It worked, I guess that is the only method, any other suggestions are welcome.

BTW slight correction in substring expression

yourDate.substring(0,2) + "-" + yourDate.substring(2,4) + "-" + yourDate.substring(4,8) as var1

and later I used TalendDate.parseDate("MM-dd-yyyy",Var.var1)

Re: String to date conversion

Anonymous — Thu, 05 Apr 2018 18:59:48 GMT

You're welcome. Thank you for the correction. I was doing it off memory so I apologize for the error. I was trying to beat others to the solution.

You could use TalendDate solution as well:

TalendDate.formatDate("MM-dd-yyyy", TalendDate.parseDate("MMddyyyy",yourDate))