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
- 3134 reads
PDF version
More in Tux Machines
- Highlights
- Front Page
- Latest Headlines
- Archive
- Recent comments
- All-Time Popular Stories
- Hot Topics
- New Members
- EasyOS 4.2.3 Released
- Review: The Murena One phone running /e/OS 1.0
- Black Box is a GTK4 Terminal App With Unique Look
- Linux 5.19-rc5
- today's leftovers
- Programming Leftovers
- today's howtos
- LINMOB.net - Weekly GNU-like Mobile Linux Update (26/2022): Plasma Mobile Gear 22.06, Ubuntu Touch OTA-23 and the MNT Pocket Reform
- The Best Desktop Environments of 2022
- Porteus 5.0 is released!
- Videos: DTOS, Compiz, DEEPIN, and More
- today's howtos
- Software: Mycorrhiza, GROWI, Digital Media Server, Aether
- elementaryOS: Updates for June, 2022
- 10 Necessary Ubuntu Apps For Everyone [Part 3]
- Programming Leftovers
- 12 Best Linux Games To Play In 2022
- Kernel: TrueNAS, Linux Plumbers Conference, and Linux 5.20
- Ubuntu Studio 22.04 LTS - New Features and Release Details
- Android Leftovers
Recent comments
10 hours 35 min ago
10 hours 37 min ago
10 hours 38 min ago
10 hours 41 min ago
10 hours 51 min ago
10 hours 52 min ago
14 hours 42 min ago
18 hours 45 min ago
19 hours 21 min ago
21 hours 9 min ago