Hello Experts:
In a previous post, I received some assistance to properly convert a string into a valid date format. See question/solution @ https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Convert-String-into-Valid-Date-Format/td-p/1096003
After having successfully made that string-to-date adjustment, I then realized that my REGEX tool now requires some tweaking. The REGEX tool precedes my string-to-date conversion.
Quick summary:
A) SELECT tool outputs string value, e.g., "Oct 13 2009 12:00AM"
REGEX tool removes time; therefore, output is now, e.g., "Oct 13 2009" (format = "Mon dd yyy")
Current issue:
- Per A), not all of my records include the "12:00AM" suffix. For instance, some records are stored as, e.g., "10/27/2008" (string).
- Therefore, any records which do NOT have the "12:00AM" suffix are converted into NULL values (see JPG below).
My question:
- How do I properly modify the REGEX tool so that all records will be converted into string "Mon dd yyy" (with or without the "12:00AM" suffix)?
- The latter format appears to be necessary as the REGEX tool is followed by a DATETIME tool which converts input string = "Mon dd yyy" into "YYYY-MM-DD".
Thank you.
