Apologies that this is "long winded" compared to the typical query on here.
Attached CSV file "Mixedbatch Tesr" contains extracts from three different CSV files sent by End User.
Rows 2 - 5 have date and time as "YYYY-MM-DD HH:MM:SS" and money as "£xxx.xx"
Rows 6 - 9 change the date and time to "YYYY-MM-DD HH:MM", and have symbol "?" in place of "£"
Rows 10 - 13 show the date as "DD/MM/YYYY HH:MM", and the "?" symbol in place of the "£"
Almost the only permutation missing so far is a US-style "MM/DD/YYYY"!
The Excel file attached opens File Manager, enables the User to select the CSV file, and converts the Text to Columns, all of which works perfectly.
Problem is the next stage. I needs it to sort into Col A date order, then name the sheet as the "Min and Max" dates in Col A (so with this sample it would be "Appts 10 April 2016 - 14 May 2016")
But the "mixed" date formats cause programme to generate "#Value", it can't sort properly, and can't find the Min and Max.
Having now rewritten the Code each month to overcome the changed format, I am hoping someone can show me the coding that will "standardise" whatever Date and Time format turns up on the CSV download?
Needless to say, the End User is adamant they "changed nothing" over the three downloads, and completely uninterested in doing anything their end.
All suggestions, pointers and improvements welcomed gratefully as usual.
Ochimus
Bookmarks