today's howtos

-
How to use the screen share feature in Ubuntu
-
How To Install and Configure Redis on Debian 10 Linux
-
40 Important Docker Commands for Software Developers
-
How to install the Abiword word processor on Linux
-
Filter by months and years in Calc pivot table
-
Data validation on entry with YAD
The best way to clean a data table? Clean the data before it gets entered.
A straightforward method is to build and check a stand-alone lookup list, then enforce the use of that lookup list for data entry. It may not be possible to do this for every field in the data table, but for a field with only a limited number of potential entries, a lookup list can save a lot of data cleaning work in future.
-
- Login or register to post comments
Printer-friendly version
- 3135 reads
PDF version
More in Tux Machines
- Highlights
- Front Page
- Latest Headlines
- Archive
- Recent comments
- All-Time Popular Stories
- Hot Topics
- New Members
Who's new
- OzarkJoe
- trendoceangd
- Onzarwadabun
- kmcmillan
- Marius Nestor
Recent comments
4 hours 11 min ago
14 hours 32 min ago
17 hours 41 min ago
19 hours 4 min ago
20 hours 3 min ago
20 hours 43 min ago
20 hours 44 min ago
20 hours 46 min ago
20 hours 58 min ago
23 hours 29 min ago