Date Handling

Anonymous — Mon, 29 Jan 2018 12:57:00 GMT

I have file in Excel and I have some fields like the following:

Date,Name of event,Venue,Host

In the date filed there are a lot anomalies, which i need to sort.

Some dates have the format as : 01-03 jan,2018

Some others have : 01 - 03jan,2018

some others have : 29 jan - 1feb, 2018

What i want to do is separate the date into 2 fields : start date and end date . The number before the "-" will be start date and later will be the end date. How can i do so in talend

Re: Date Handling

Anonymous — Mon, 05 Feb 2018 06:20:28 GMT

Hello,

From your description, the TalendHelpCenter:tExtractDelimitedFields component will generate start date and end date columns from your date field.

and the "-" can be set as field separator.

Best regards

Sabrina

topic Date Handling in Talend Studio

Date Handling

Re: Date Handling