14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→check if field contains value
| Line 27: | Line 27: | ||
== check if field contains value == | == check if field contains value == | ||
length of string > 0 | |||
* MySQL: {{kbd | key = SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) != 0;}} [http://sqlfiddle.com/#!2/f491c/1/0 demo] | |||
column value is not {{kbd | key = null}} or {{kbd | key = 0}} | |||
* Excel: {{kbd | key = COUNTIFS(criteria_range1, "<>NULL", criteria_range1, "<>0")}}<ref>[https://www.ablebits.com/office-addins-blog/2014/07/10/excel-countifs-multiple-criteria/ Excel COUNTIFS and COUNTIF with multiple criteria – examples of usage]</ref> | |||
== verify the format of field value == | == verify the format of field value == | ||