topic Re: Convert String "(11 MAY 2011)" to Date in Talend Studio

Convert String "(11 MAY 2011)" to Date

Anonymous — Fri, 25 May 2018 16:30:27 GMT

Hello community,

I want to convert string to date(dd/mm/yyy) ,The string has a forme (11 MAY 2011)

when i try to use the function TalendDate.parseDate("dd/mm/yyyy",row1.nomduchamps) i get an error

Please any help

Thanks in advance

Re: Convert String "(11 MAY 2011)" to Date

Anonymous — Sat, 26 May 2018 15:58:32 GMT

Hello Lilya,

I tried TalendDate.parseDateInUTC("dd MMM yyyy","11 MAY 2011") and it worked.
Here as per your query the type of input argument("11 MAY 2011") is String.
I kept Data type of destination column as Date and "dd-MM-yyyy" as Date Pattern.
It returned 11-05-2011 as output
Hope it helps !!

Thanks,
Trupti

Re: Convert String "(11 MAY 2011)" to Date

Anonymous — Sun, 27 May 2018 18:39:25 GMT

i'm trying your solution(TalendDate.parseDateInUTC("dd-MMM-yy",row1.STMDMVT))

but i get this error

java.lang.RuntimeException: java.text.ParseException: Unparseable date: " "

Thinks

Re: Convert String "(11 MAY 2011)" to Date

TRF — Sun, 27 May 2018 22:40:58 GMT

@shima row1.STMDMVT is probably null or empty (or may contains a space character based on your message)

Re: Convert String "(11 MAY 2011)" to Date

jilanisyed — Mon, 28 May 2018 08:37:41 GMT

Hi Liya,
Try the following code in tmap.

TalendDate.parseDate("dd MMM yyyy",row1.DateString)

Re: Convert String "(11 MAY 2011)" to Date

SachinD — Mon, 28 May 2018 09:24:12 GMT

DateString.jpg