Sorting formatted number (currency)

Sorting formatted number (currency)

sithot28sithot28 Posts: 1Questions: 0Answers: 0
edited March 2009 in General
Thanks for your great plugin.
I want to know how to sorting column contains formatted number (currency) with thousand separator (.) and decimal ? anyone pls share your knowledge

Replies

  • allanallan Posts: 54,909Questions: 1Answers: 8,606 Site admin
    Hi,

    There is a currency sorting plug-in available on the plug-ins page: http://www.datatables.net/plug-ins , and example of type detection and custom sorting here: http://datatables.net/examples/example_sorting_plugin.html .

    You might have to modify the currency sorting plug-in slightly to match your exact requirements (for example to deal with the thousand separator).

    Hope this helps,
    Allan
  • naspinskinaspinski Posts: 13Questions: 0Answers: 0
    I posted the method I use in another thread:
    http://datatables.net/forums/comments.php?DiscussionID=6&page=1#Item_5
This discussion has been closed.