Weekly challenge 4 done.
I really enjoyed working on this solution because I appreciate the advantages of regular expressions. On my first try, I did a long version of columns using additional regex tools; on my second try, I used a slightly different approach with a single regex tool. Somehow on this last try, I ended up parsing a T on column 6.
I guess that I should have used the two or more digits option instead of forcing the two and four digit year onto their own columns.