Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
this is yet the natural sorting for the field, describe better your scenario
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"