Hi,

I was wondering if there is any smart way you can sort lists of numbers with
some common features:

Ex:

99a0022-D.pdf
99a3065_2-3.pdf
9.9A-3068 Steel Structure
9.9A-3068 Steel Structure for GGH
99a3068 rev 4com.pdf
99a3068-1_1.pdf


You may notice that there are four digits in all of these files. However,
they are in different positions making the built in sorting function useless.
Is there any smart way to sort them according to the four digits and then
(the following numbers/letters) based on normal rules applied when sorting?



When this is done (I trust that you can help me!), Id like each file (the
ones first in line) with a unique four digit set to be copied into the row to
the right.


Ex:
99a0019_1-1.pdf 99a0019_1-1.pdf
99a0019_2-1.pdf
99a0021_1-1.pdf 99a0021_1-1.pdf
99a0021_2-1.pdf
99a0022-0.pdf 99a0022-0.pdf
99a0022-1.pdf
9.9A-3068 Steel Structure for A 9.9A-3068 Steel Structure for A
9.9A-3068 Steel Structure for B


Thank you! I look forward to hearing some smart ideas.

--
Kind regards, Nic