14,970
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→verify the format of field value
| Line 139: | Line 139: | ||
== verify the format of field value == | == verify the format of field value == | ||
related page: [[Regular expression]] | |||
=== email contains @ symbol === | === email contains @ symbol === | ||
* EXCEL: {{kbd | key =<nowiki>=IF(ISERR(FIND("@", A2, 1)), FALSE, TRUE)</nowiki>}} only check the field if contains @ symbol or not | * EXCEL: {{kbd | key =<nowiki>=IF(ISERR(FIND("@", A2, 1)), FALSE, TRUE)</nowiki>}} only check the field if contains @ symbol or not | ||