Custom Sort Order by Varchar Column

[#1]

Hi All,

I have a data  in a column with the below format .I need to sort by column.Can anyone help.

Column

1

1.1

1.1.1

1.1.2

1.1.2.7

1.1.2.8

1.1.2.9

1.1.3

1.1.3.3

1.1.3.4

1.1.3.8

1.1.3.9

1.1.3.10

[alexandros17]

this is yet the natural sorting for the field, describe better your scenario

[#3]

You can use subfields:

sort by this expression: Subfield(column,'.',3)  which will return:

blank

blank

1

2

2

2

2

3

3

3

3

3

3

Or sort by: Subfield(column,'.',4) to sort on your last "column"