Clear questions and runnable code
get the best and fastest answer
Yours is a much better solution than my simple one.
Although my solution works for the example given, it does assume that all filenames are of the format provided in the original post and does not take into consideration the examples you provided.
Thanks for the feedback and great sample code!