topic Re: Unparseable date "null" in Talend Studio

Unparseable date "null"

Anonymous — Sat, 16 Nov 2024 14:04:53 GMT

Hi,
I work on TIS 2.4.2. and I have a problem with some dates.
I have a source datebase that have a field date that can be sometimes "null"
And I tried to :
- convert it to string in the SQL request
- I tried to change the type in a schema of the source to String
- I tried to make a condition in a tmap : date.equals("null")? " ":date or I tried date == "null"? " ":date
What I have to do? create a routine?
Thanks in advance

Re: Unparseable date "null"

Anonymous — Mon, 09 Feb 2009 09:28:58 GMT

Hi,
If your date input is string, try with :
date.equals("")?null:TalendDate.ParseDate("MM-dd-yyyy HH:mm:ss",date)

I had a case like this, for exemple :
(input_map.DT_DEB_VALID_OBJ.equals(""))?null:TalendDate.parseDate("MM/dd/yyyy",input_map.DT_DEB_VALID_OBJ)
Best Regards,
Guillaume.

Re: Unparseable date "null"

Anonymous — Mon, 09 Feb 2009 09:59:27 GMT

But my input is not a String It's a date.
And I already tried what you propose.
In addition, It's not " " but null that I have on my source database so it's not the same case.
But thanks

Re: Unparseable date "null"

Anonymous — Mon, 09 Feb 2009 10:14:00 GMT

In fact I have a problem to read a date that is null

Re: Unparseable date "null"

Anonymous — Mon, 09 Feb 2009 10:17:23 GMT

not sure what exactly ur requirement is
what i understood is , u r trying tp parse thedate and it is hitting null pointer exception.
if this is the case
try
null != date? parse : do not parse or set it to null
hopr this would help

Re: Unparseable date "null"

Anonymous — Mon, 09 Feb 2009 10:30:23 GMT

thanks I will try

Re: Unparseable date "null"

Anonymous — Mon, 24 Nov 2014 09:17:39 GMT

thanks i had same issue with " "
date.equals("")?null:TalendDate.ParseDate("MM-dd-yyyy HH:mm:ss",date)

and I tried and it works for me

Re: Unparseable date "null"

_AnonymousUser — Mon, 18 Apr 2016 07:38:58 GMT

How to handle null value in talend.I m using date data type.at the time of excel writing i m unable to handle null value.

Re: Unparseable date "null"

_AnonymousUser — Mon, 18 Apr 2016 07:40:35 GMT

How to handle null date value in talend.I m using date data type.at the time of excel writing i m unable to handle null value.plz provide sme suggestion