BUILDING PHILOSOPHY LIFESTYLE HABITS ADVICE CAREERS BUSINESS ENTERPRISE SELLING

<
#85
>


How can you clean input data?

If you're going to "diagnose the state of your data", why not clean it up. There's so much that you can do at entry time, at retrieval time, and at any time between:

- wash non-printable characters

- wash illogical (depending upon context) characters

- trim leading and trailing spaces

- verify check digits

- verify lookups

- verify against standards (USPS, etc.)

- add Soundex, Metaphone, levenshtein, etc.

- build a context suitable hash

- add Soundex, Metaphone, levenshtein, etc. to the hash

- wash standard keywords

Tech books make you Good.  People books make you Better...
and
coming
fall
2017...
 
LERN
HOW
TOO
RITE
dont let bad riting hold u back
50 Documents
Every Programmer
Must Be Able to Write
ED WEISSMAN

All email answered.  edw519 at gmail
Copyright © 2017 Ed Weissman