RegEx isn't my strength and a similar issue prevented me from finishing my Designer Cloud Core Cert exam. Now that I have figured out one way to accomplish this, I really want to figure out if there is a better way. If I had a string column that contained two different types of date formats and I wanted to change them to the same format, I am wondering what the most efficient way to do this is? For example, let's say the column had the data type of string and contained dates formatted like the example below and I wanted them all in the Alteryx standard of yyyy-MM-dd. I accomplished this by extracting one of the date formats to its own column as an array, extracting the value, and then by changing the data type and format. For the date left in the original column: I changed the data type of the column to date, then changed the date format. The last step was with a formula to replace the null values in the original column with the dates from the other date column. It worked, but was a lot of steps and created a couple of extra columns that had to be deleted. Thank you in advance for any assistance!!
| Date |
| 2015-09-15 |
| September 18, 2018 |
| 2018-09-01 |
| November 27, 2020 |
| Date | Date split | Date split1 | | |
| 2015-09-15 | [] | | | |
| | [September 18, 2018] | 2018-09-18 | | |
| 2018-09-01 | [] | | | |
| | [November 27, 2020] | 2020-11-27 | | |
| | | | | |
