get values from table as key value pairs with jquery

Posted by liz on Stack Overflow See other posts from Stack Overflow or by liz
Published on 2010-06-03T17:17:37Z Indexed on 2010/06/03 17:24 UTC
Read the original article Hit count: 277

Filed under:
|

I have a table:

<table class="datatable" id="hosprates">
                <caption> hospitalization rates test</caption> <thead>
                <tr>
                    <th scope="col">Funding Source</th> <th scope="col">Alameda County</th> <th scope="col">California</th>
                </tr>
                </thead>
                <tbody>
                    <tr>
                        <th scope="row">Medi-Cal</th>
                        <td>34.3</td>
                        <td>32.3</td>
                    </tr>
                    <tr>
                        <th scope="row">Private</th>
                        <td>32.2</td>
                        <td>34.2</td>
                    </tr>
                    <tr>
                        <th scope="row">Other</th>
                        <td>22.7</td>
                        <td>21.7</td>
                    </tr>
                </tbody>
            </table>

i want to retrieve column 1 and column 2 values per row as pairs that end up looking like this [funding,number],[funding,number]

i did this so far, but when i alert it, it only shows [object, object]...

  var myfunding =  $('#hosprates tbody tr').each(function(){
  var funding = new Object();

  funding.name = $('#hosprates tbody tr td:nth-child(1)').map(function() {
              return $(this).text().match(/\S+/)[0];
             }).get();
  funding.value= $('#hosprates tbody tr td:nth-child(2)').map(function() {
              return $(this).text().match(/\S+/)[0];
             }).get();

});
alert (myfunding);

© Stack Overflow or respective owner

Related posts about JavaScript

Related posts about jQuery