This is probably almost out of scope, but I am using a VFP program to make it happen.

I have a directory of drawing files named as such 117851F1.pdf, 117851F2.pdf, 117851F3.pdf etc. With automation code I want to make these into one pdf file which I have no problem doing. However, the trouble I have is properly looping through the files in the directory to make sure the first file is F1, second F2 etc. This really gets shakey when there are more than nine files then I have 117851F1, 117851F10, 117851F2. One more complication is some times the file names are a bit longer example: 117853-401F1, 117853-401F2. How can I make sure when I go to insert a page into my pdf file I really have the proper drawing sheet?