Sorting Number and Blanks, -, or N/A

  • Resolved CaptainsLog

    (@captainslog)


    7 years, 2 months ago

    I am trying to get numbers to sort so that anything blank ends up last in a list, not first.

    For instance, on this page: https://mbaguide.org/mba-programs-ranked-enrollment-full-time-students/, if you sort on the Master’s degree, you can see that ‘-‘ comes up first and not the lowest number. I would prefer it to come up last.

    We tried N/A and table didn’t sort correctly.

    We are using the following extensions provided by you:
    – TablePress Extension: DataTables Sorting plugins
    – TablePress Extension: DataTables HTML Numbers in Tables

    Is there a solution, a character, or something that would show up last and play nice with other numbers?

    Thanks,

    Jeff

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    I see what you mean, but unfortunately, I’m not aware of a solution to this ?? Sorry.
    Most likely, you would have to develop a custom sorting algorithm (similar to those in the DataTables Sorting Plugins Extension), that adds special treatment to the - character. Right now, the - is treated like a 0, from what I know.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Sorting Number and Blanks, -, or N/A’ is closed to new replies.