14,962
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→is null
| Line 180: | Line 180: | ||
Find whether a variable is NULL. [http://ideone.com/tKv2gQ online demo] | Find whether a variable is NULL. [http://ideone.com/tKv2gQ online demo] | ||
* PHP [http://tw2.php.net/is_null is_null] | * PHP [http://tw2.php.net/is_null is_null] to find type:null null NOT type:string <nowiki>'null'</nowiki> {{exclaim}} | ||
* Google spreadsheet / Excel: | * Google spreadsheet / Excel: | ||
** [https://support.google.com/drive/answer/3093348 ISERR(value)] " value - The value to be verified as an error type other than #N/A." ex: {{kbd | key = #NULL!}} | ** [https://support.google.com/drive/answer/3093348 ISERR(value)] " value - The value to be verified as an error type other than #N/A." ex: {{kbd | key = #NULL!}} | ||