14,962
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→is null
| Line 188: | Line 188: | ||
Find whether a variable is NOT NULL | Find whether a variable is NOT NULL | ||
* MySQL SQL syntax: {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}} | * MySQL SQL syntax: {{kbd | key = SELECT * FROM table WHERE column IS NOT NULL;}} | ||
Find whether a variable is NOT {{kbd | key = #N/A}} | |||
* Excel: {{kbd | key = =NOT(ISERROR(cell_value))}} | |||
javascript | javascript | ||