This was very helpful -- thank you!
Question - There are a lot of plausible solutions to this (Formula with Trim v. Data Cleansing Tool v. RegEx or DateTime function v. Formula tool on date) and also potential order of functions (e.g. selecting/renaming before/after tackling character or date formatting). Is there an optimal solution to this for computational effort? Or generally a list on which functions in Alteryx are more taxing on the system than others?