Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution
quick and easy one, but useful because I hadn't used this tool yet.
DateTime tool creates new column with converted field.
Given that I would use the Select tool early on, I placed DateTime first, to avoid extra operations.
Assuming potentially more rows, I generally use Data Cleansing tool to Remove Unwanted Characters: Leading and Trailing Whitespace and Tabs, Line Breaks, and Duplicate Whitespace.
Any suggestions on how (if) this could be more efficient? :)