Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADone!
My solution
My solution with comments:
1. Text to columns to split the Field 1 to 3 separate fields
2. Data cleanse to remove all punctuation
3. DateTime to convert String format to required output date format (used Custom incoming date format from output of data cleanse - ddMonyy)
4. Final Select to keep only the required 3 fields