ordering column by number, ignoring text (last)

ordering column by number, ignoring text (last)

BusterenBusteren Posts: 52Questions: 17Answers: 4

As the title says, is there a way to order by number, where the highest numbers are first. But text will be ignored and placed at the end?

Regards T

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 63,464Questions: 1Answers: 10,466 Site admin
    Answer ✓

    There isn't a built in way to do that, but there is no reason why a plug-in ordering method couldn't be written to do that.

    You might be interested in reading over this blog post if you do decide to write such a plug-in as it does something very similar, but looking for specific strings rather than simply checking between numbers and strings.

    If you write the plug-in, I'm sure others would be very appreciative if you were able to share it with us.

    Regards,
    Allan

  • BusterenBusteren Posts: 52Questions: 17Answers: 4

    Thank you, will have a look. If I get something working I will definitely post it.

This discussion has been closed.