Search for any string in column - all except empty cells

Search for any string in column - all except empty cells

awariatawariat Posts: 7Questions: 3Answers: 0

Hi
To search for empty string in column cells, I found to use:

table.column(28).search( '^$', true, false ).draw();

But how to search for NOT empty strings and remove all empties?
I need only rows where I have at least one character in a cell.
Kind regards
Jack

This question has an accepted answers - jump to answer

Answers

  • kthorngrenkthorngren Posts: 21,374Questions: 26Answers: 4,957
    Answer ✓

    Try this:

    table.column(28).search( '^.+$', true, false ).draw();
    

    The .+ requires at least one character.

    Kevin

  • awariatawariat Posts: 7Questions: 3Answers: 0

    Thank you very much

Sign In or Register to comment.