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
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.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.