You have a structured data file you need to process. I'll use CSV here but it could be any data format that SCL supports. It has all the information you need but the date fields are spread out across multiple columns and several different date formats are used.
In this blog post I'll show how to use SCL to combine all the date fields into one and how to handle multiple formats