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
- 3108 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
5 hours 52 min ago
8 hours 11 min ago
8 hours 17 min ago
19 hours 5 min ago
1 day 2 hours ago
1 day 5 hours ago
1 day 13 hours ago
1 day 13 hours ago
1 day 17 hours ago
1 day 18 hours ago