Databases
StackOverflow2013
Postsdbo
POSort javascript array so that blank values are always at bottom
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSort javascript array so that blank values are always at bottom
    primarykey
    data
    text
    <p>So I have an array of arrays which contain only strings. The array of arrays is to be displayed as a table and may have over 1000 rows with 20 or more values in each.</p> <p>eg:</p> <pre><code>var arr = [ ["bob","12","yes"], ["joe","","no"], ["tim","19","no"], ["dan","","yes"], ["tim","",""], ["dan","0",""] ] </code></pre> <p>the strings may contain anything that can be represented as a string, including: <code>" "</code>, <code>""</code>, <code>"0"</code> or <code>"00-00-00"</code> etc... and any column my be used for ordering.</p> <p>I am sorting the arrays ascending and descending but some of the values I am sorting by are blank strings: <code>""</code>. How could I get the blank strings (only) to always be at the end of the new arrays in all modern browsers?</p> <p>currently they are at the end when ascending but at the start when descending.</p> <p>I am sorting like below (Yes I'm sure I can do it shorter too):</p> <pre><code>if (direction == "asc") { SortedArr = arr.sort(function (a, b) { if (a[colToSortBy] == '') { return -1; } if (a[colToSortBy].toUpperCase() &lt; b[colToSortBy].toUpperCase()) { return -1; } if (a[colToSortBy].toUpperCase() &gt; b[colToSortBy].toUpperCase()) { return 1; } return 0; }); } else { SortedArr = arr.sort(function (a, b) { if (a[colToSortBy] == '') { return -1; } if (b[colToSortBy].toUpperCase() &lt; a[colToSortBy].toUpperCase()) { return -1; } if (b[colToSortBy].toUpperCase() &gt; a[colToSortBy].toUpperCase()) { return 1; } return 0; }); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChris J
    1. USChris J
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COwhy don't you `return 1` in the first `if` of both sorts when checking empty strings? Doesn't that do the trick?
      singulars
      1. POSort javascript array so that blank values are always at bottom
      1. USRobert Koritnik
    2. CO@RobertKoritnik I did try that and the bank values ended up in between other values
      singulars
      1. POSort javascript array so that blank values are always at bottom
      1. USChris J
    3. COI've just tried your sample data and sorted on the second column (which has empty strings) and changing `return -1` to `return 1` in ifs checking empty strings and they indeed got to the end. You've probably sorted some other column to get them in the middle. The first column (array index 0 since index is zero based) seems to do just that.
      singulars
      1. POSort javascript array so that blank values are always at bottom
      1. USRobert Koritnik
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload