topic Re: how to split day month year from a date format in Talend Studio

how to split day month year from a date format

Anonymous — Thu, 02 Aug 2018 13:12:58 GMT

hello,

i have a birth_date column '1962-02-19 00:00:00' "yyyy-MM-dd" format

i want to split birthday-month-year and load it to three different database table.

please help me out

Thanks & regards

Manish

TRF — Thu, 02 Aug 2018 13:37:46 GMT

TalendDate.getPartOfDate

iamabhishek — Thu, 02 Aug 2018 13:37:59 GMT

You could use tExtractRegexFields to split your input data into three parts.

Something like this -

And have your regular expression defined as -

"([0-9]*)-([0-9]*)-([0-9]*)"

and the schema as -

Once you have done with your data split then you could have your database output defined accordingly.

manodwhb — Thu, 02 Aug 2018 13:42:41 GMT

@vitspltalend,please find below tMap configuration,you can implement in this way also.

manodwhb — Thu, 02 Aug 2018 13:52:09 GMT

you can convert belo way also.