topic Re: Date Scenario how can handle this in Talend Studio

Date Scenario how can handle this

Anonymous — Wed, 10 Oct 2018 10:50:55 GMT

hello everyone,

how can i handle this type of date format,

i want to split it on 3 files like

26 Dec 1955 ---> dd MMM yyyy -->||File 1

1944--> yyyy -->||File 2

Circa 1996 ---> file 3

the original data is same as like this:-

Date Of Birth

26 Dec 1955

1944

1945

1955

Circa 1996

Re: Date Scenario how can handle this

Anonymous — Wed, 10 Oct 2018 11:05:39 GMT

An easy way would be to use a tMap with 3 outputs (Circa_out, Year_out and Date_out). If the String value containing the date is 4 characters long, it must be the Date_out. If the String contains "Circa" it is the Circa_out. Otherwise it is the Date_out. You can use the output filters in the tMap to calculate this.

Re: Date Scenario how can handle this

Anonymous — Wed, 10 Oct 2018 11:58:29 GMT

thanks sir, it works, but in "circa" filter is not working,

what can i do in find "circa 1955" values?

Re: Date Scenario how can handle this

Anonymous — Wed, 10 Oct 2018 12:02:20 GMT

You can use something like....

row.Column.toUpperCase().indexOf("CIRCA")>-1

.....to solve this

Re: Date Scenario how can handle this

Anonymous — Wed, 10 Oct 2018 14:58:15 GMT

It's not working, gives some error "Exception in component tMap_2 (date_function2)
java.lang.NullPointerException"

Re: Date Scenario how can handle this

Anonymous — Wed, 10 Oct 2018 15:13:04 GMT

This means your data is null. You will have to handle nulls as well. Add something like....

row.Column!=null ? {your processing code} : {your response if the column is null}