有一组数据 用的jquery tablesort插件排序 单纯数字 日期的排好了 但是有组数据 怎么都排不好谁能帮我下、数据如下 其中--表示0:
58nGy/h
62nGy/h
68nGy/h
69nGy/h
72nGy/h
74nGy/h
75nGy/h
76nGy/h
80nGy/h
82nGy/h
88nGy/h
90nGy/h
92nGy/h
95nGy/h
97nGy/h
100nGy/h
102nGy/h
106nGy/h
106nGy/h
108nGy/h
110nGy/h
116nGy/h
120nGy/h
10nGy/h
16nGy/h
18nGy/h
--nGy/h
--nGy/h
jquery

解决方案 »

  1.   


     $(function() {
    $("table").tablesorter({
    textExtraction:function(node ){
     var text=$(node).text()
     return text=='--nGy/h'?'0':text;


    });
    }); 
      

  2.   

    我看了下是数字类型是可以排序的啊。
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <!-- meta -->
         <title>MITYA.CO.UK &nbsp;|&nbsp; Scripts &nbsp;|&nbsp; Animated table sort (REGEXP friendly)</title>
         <meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1" />
         <meta name="description" content="Mitya.co.uk - scripts, plugins and tutorials for Javascript, jQuery and PHP. Check out my web development blog for the latest updates." />
    <meta name="keywords" content="web development, coding, Javascript, jQuery, plugins, AJAX, PHP, MySQL, database, UI, browsers, Opera, Internet Explorer, Firefox, Chrome, Safari, DOM, GD, REGEXP, regular expressions, Andy Croxall, mitya, table, sort, animation" />
            <meta name='robots' content='index, follow' /> <!-- CSS -->
    <link rel="stylesheet" type="text/css" href="http://mitya.co.uk/scripts/../css/main.css" />
    <link rel="stylesheet" type="text/css" href="http://mitya.co.uk/scripts/../css/codeColouring.css" />

    <link rel='stylesheet' type='text/css' href='http://mitya.co.uk/scripts/../css/scriptDemos.css' />

    <!-- JS -->
    <script type='text/javascript'>var SITE_ROOT = "http://www.mitya.co.uk";</script>
    <script type="text/javascript" src="http://mitya.co.uk/scripts/../inc/js/jquery-1.6.1.min.js"></script>
    <script type="text/javascript" src="http://mitya.co.uk/scripts/../inc/js/common.js"></script>

    <script type="text/javascript" src="http://mitya.co.uk/scripts/../scripts/source/99.js"></script>

    </head> <body>
      <script src='http://mitya.co.uk/scripts/source/111.js' type='text/javascript'></script>
    </p><div class='scriptDemo'>
    </p><table id='example1_table' class='table'><thead><tr><th><a class='bold' href="javascript:$('#example1_table').sortTable({onCol: 1, keepRelationships: true})">Place</a></th><th><a class='bold' href="javascript:$('#example1_table').sortTable({onCol: 2, keepRelationships: true})">County</a></th><th><a class='bold' href="javascript:$('#example1_table').sortTable({onCol: 3, keepRelationships: true, sortType: 'numeric'})">Phone code</a></th><th><a class='bold' href="javascript:$('#example1_table').sortTable({onCol: 4, keepRelationships: true, sortType: 'numeric'})">Approx. population</a></th></tr></thead><tbody><tr><td>Nottingham</td><td>Nottinghamshire</td><td>0115</td><td>58nGy/h</td></tr><tr><td>Luton</td><td>Bedfordshire</td><td>01582</td><td>203800</td></tr><tr><td>Huddersfield</td><td>Yorkshire</td><td>01484</td><td>106nGy/h</td></tr><tr><td>Carlisle</td><td>Cumbria</td><td>01228</td><td>103700</td></tr><tr><td>Brighton</td><td>East Sussex</td><td>01273</td><td>155919</td></tr><tr><td>Woking</td><td>Surrey</td><td>01483</td><td>62796 </td></tr><tr><td>Basingstoke</td><td>Hampshire</td><td>01256</td><td>--nGy/h</td></tr><tr><td>Rhyll</td><td>Clwyd</td><td>01745</td><td>--nGy/h</td></tr></tbody></table></div>
    </p><p>
    </p><p>Here's the code applied to the links in the <span class='code'>&lt;th&gt;</span>s:
    </p><p>
    </p><div class='code'><p>
    <span class='lineNum'>1</span><span class='code_comment'>//column <span class='code_number'>1</span> - by place name</span>
    </p><p><span class='lineNum'>2</span><span class='code_func'>$</span>(<span class='code_string'>'#example<span class='code_number'>1</span>_table'</span>).<span class='code_func'>sortTable(</span>{
    </p><p><span class='lineNum'>3</span> &nbsp; &nbsp; onCol: <span class='code_number'>1</span>,
    </p><p><span class='lineNum'>4</span> &nbsp; &nbsp; keepRelationships: true
    </p><p><span class='lineNum'>5</span>});
    </p><p><span class='lineNum'>6</span><span class='code_comment'>//column <span class='code_number'>2</span> - by county</span>
    </p><p><span class='lineNum'>7</span><span class='code_func'>$</span>(<span class='code_string'>'#example<span class='code_number'>1</span>_table'</span>).<span class='code_func'>sortTable(</span>{
    </p><p><span class='lineNum'>8</span> &nbsp; &nbsp; onCol: <span class='code_number'>2</span>,
    </p><p><span class='lineNum'>9</span> &nbsp; &nbsp; keepRelationships: true
    </p><p><span class='lineNum'>10</span>});
    </p><p><span class='lineNum'>11</span><span class='code_comment'>//column 3 - by phone code</span>
    </p><p><span class='lineNum'>12</span><span class='code_func'>$</span>(<span class='code_string'>'#example<span class='code_number'>1</span>_table'</span>).<span class='code_func'>sortTable(</span>{
    </p><p><span class='lineNum'>13</span> &nbsp; &nbsp; onCol: 3,
    </p><p><span class='lineNum'>14</span> &nbsp; &nbsp; keepRelationships: <span class='code_word'>true,</span>
    </p><p><span class='lineNum'>15</span> &nbsp; &nbsp; sortType: 'numeric'
    </p><p><span class='lineNum'>16</span>});
    </p><p><span class='lineNum'>17</span><span class='code_comment'>//column 4 - by approx. population</span>
    </p><p><span class='lineNum'>18</span><span class='code_func'>$</span>(<span class='code_string'>'#example<span class='code_number'>1</span>_table'</span>).<span class='code_func'>sortTable(</span>{
    </p><p><span class='lineNum'>19</span> &nbsp; &nbsp; onCol: 4,
    </p><p><span class='lineNum'>20</span> &nbsp; &nbsp; keepRelationships: <span class='code_word'>true,</span>
    </p><p><span class='lineNum'>21</span> &nbsp; &nbsp; sortType: 'numeric'
    </p><p><span class='lineNum'>22</span>});</p></div>
    </p><p>
    </p>
     </body>
    </html>
      

  3.   

    额 数字类型是可以   但是加上nGy/h之后顺序就乱了  
      

  4.   

    实在不行debug 看下到底什么地方排序数据不对。。