How to sort 1.1.1.1 format?

EricYiu

Let say I have

1.1.2
1.1.2.10
1.1.2.1
1.1.2.11
1.1.2.2
1.1.2.3
1.1.2.4
1.1.2.5
1.1.2.6
1.1.2.7
1.1.3
1.1.4
1.1.4.1

How can I sort the output result like this?

1.1.2
1.1.2.1
1.1.2.2
1.1.2.3
1.1.2.4
1.1.2.5
1.1.2.6
1.1.2.7
1.1.2.10
1.1.2.11
1.1.3
1.1.4
1.1.4.1

LordNeilLord

Hey @EricYiu 

This might work for you...

Essentially you need to split out the value into rows, pad the out with zero's (i did 5 but you can choose as many as you want) then concatenate it all back together, which will then give you the ability to sort.

Neil

Sort thing.yxmd