We name a record with field x simply a record.

Any record with a non numeric infront of the first or none dot is trailing any record with numerics in front of first or none dot.
Numerics and non numerices should not be mixed with in a group delimited by dots.
Numerics should be orderd numerical.
Non numerics could be any letter [A..Z]+ and should be ordered like numericals A,B,AA,AB, AAC (there is a small chance to talk customer into alphabetical order, because AA is not very likely)
With in the order given above the following groups should follow this. It's high probalility to have just groups of .1 and .R now, but I don't like to run in it the other day.

Nun ist es bestimmt klar wie Kloßbrühe ... :(

>the ordering of "03" needs converting via value, ordering "AA" after "B" might imply converting via Hex or at least a padl(), but then you will give me an item with a letter beyond "F" like "R" in first spot or n- letter groups ? Can you define the ordering algorithm in words?
>
>//upd: if you can define a max length between dots, a max # of dots (arbitrarily high would be enough) and can exclude all chars not in ["0".."9"] or ["A".."Z"]
>you could build an ordering string of padl() columns, see example down below in your ordered data, with comment on "03"