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

[KIYONG]

Hi, can you try this?

[EricYiu]

Thx for the solution, But if the format is dynamic and may get more than ten dot, is there a smart way to sort them?

[LordNeilLord · Accepted solution]

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

[EricYiu]

HI Lord, It works... Much thx for the solution.