Replies

• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  November 2012

  Hi Maddy,
  
  It sounds like this plug-in might be the best option for you: http://datatables.net/plug-ins/sorting#formatted_numbers . It simply strips non-numeric data from the source and then sorts what remains numerically.
  
  Allan
• girishmr Posts: 137Questions: 0Answers: 0

  November 2012

  I use the following js library for accounting fields.
  http://josscrowcroft.github.com/accounting.js/
  
  Hope this might help you
• Maddy Posts: 24Questions: 0Answers: 0

  November 2012

  Thanks a lot for the responses. I added the formatting at the source itself (in PHP). Here's the function I used -
  
  setlocale(LC_MONETARY, 'en_US.UTF-8'); at the beginning of the php.
  
  money_format('%(#10n', $cost)
• girishmr Posts: 137Questions: 0Answers: 0

  November 2012

  Well it depends on what one wants in the project. Personally I would prefer to format the fields only during display. If you do it in PHP, sometimes you might have to strip down all these extras before calculations are done.
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  November 2012

  Agreed - formatting upon display ( `mRender` for type `display` for example). See: http://datatables.net/blog/Orthogonal_data (mainly talks about mData but mRender is similar).
  
  Allan