Hi everyone,
I have a situation where I import the contents of a csv file that includes a date field.
The format of the date field can be variable as I have no real control over its creation.
I have used the sc_date_conv macro for date fields like 12/12/15 and 12-12-15 and 12.12.15 but now I have come across a csv file where the date is recorded in the format
12-Jan-15.
I do not think that sc_date_conv can handle alpha characters, and I suppose I could do some string manipulation using some switch/case code to remove the alpha and replace it with numeric before the sc_date_conv does its work.
However, if there is an easier way, I am all ears.
Thanks
Tony