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
- 3153 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
9 hours 14 min ago
13 hours 13 min ago
13 hours 15 min ago
1 day 20 hours ago
1 day 21 hours ago
1 day 22 hours ago
1 day 22 hours ago
1 day 22 hours ago
2 days 1 hour ago
2 days 2 hours ago