• Registered: 2014-02-14
  • Posts: 10,294

Topic: Sorting column n1-n2-n3

Sorting column n1-n2-n3


For example:
3-34-1
3-34-2
..........
3-34-10
............
3-36-1


In the settings of TableGrid1 (or button configuration using the "Search"), choose to sort ORDER BY and paste the following condition:

CAST (trim(substr(replace(fieldnumber, '-', '     '), 1, 3)) AS INTEGER), CAST (trim(substr(replace(fieldnumber, '-', '     '), 7, 5)) AS INTEGER), CAST (trim(substr(replace(fieldnumber, '-', '     '), 12)) AS INTEGER)

where fieldnumber - text field type

http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=639&download=0



Download project:
http://myvisualdatabase.com/forum/misc. … download=1

Dmitry.