How to parse a column with multiple data formats

Options
rtaylor
rtaylor Registered Posts: 24 ✭✭✭✭✭

I am looking at the Prepare recipe, and trying to parse a column to date, but I have multiple date formats in the column. For example I have both:

  1. 7/9/2019 1:24:30.897000 AM
  2. 2019-07-07-09.10.59.779000

I do not see that is is possible to have a Prepare recipe parse a column conditionally, e.g. check for format, then parse accordingly. It appears that I must pick one format to parse in. Is there any way to solve for this in the Prepare recipe?

Answers

Setup Info
    Tags
      Help me…