topic Re: Error convert String to Date in Talend Studio

Error convert String to Date

Anonymous — Tue, 23 Jun 2020 14:20:11 GMT

Hi All,

I want to convert string to date, but error is shown:

Exception in component tMap_4 (testbrna)
java.lang.NullPointerException
at java.text.SimpleDateFormat.parse(Unknown Source)
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:928)
at routines.TalendDate.parseDate(TalendDate.java:886)
at test.testbrna_0_1.testbrna.tFileInputExcel_4Process(testbrna.java:1620)

Kindly help. Thank you in advance

Re: Error convert String to Date

jeoste — Tue, 23 Jun 2020 21:18:36 GMT

Hello ! The NPE (Nullpointer exception) is telling you that your current output data is null. Which means : TalendDate.parseDate("M/d/y", row4.Date) is null. Try to catch the error output like this

You will see which lines is empty. Then you have to debug the input of your flow to fix the null date

Re: Error convert String to Date

David_Beaty — Wed, 24 Jun 2020 16:50:35 GMT

Hi,

You should also consider using the TalendDate.isDate() method in the tMap or a tSchemaComplianceCheck component prior to the tMap to filter out rows that don't match the format you're expecting.