I would like to import a csv file that contains a column of times in the following format,
2020-09-02T16:31:44.427Z
I am using the File Import Wizard, which can apply a custom date format to strings and read them in as datetime values. However there does not seem to be an option to ignore non-date characters like the T and Z in the string above. Is this possible to do, using the pulldown menu? If not I will read it in as text and extract the date/time components.
Best Answer