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
- 3133 reads
PDF version
More in Tux Machines
- Highlights
- Front Page
- Latest Headlines
- Archive
- Recent comments
- All-Time Popular Stories
- Hot Topics
- New Members
- July 2022 (111)
- June 2022 (1211)
- May 2022 (1127)
- April 2022 (1130)
- March 2022 (1232)
- February 2022 (1022)
- January 2022 (1178)
- December 2021 (1206)
- November 2021 (1140)
- October 2021 (1117)
- September 2021 (1132)
- August 2021 (1125)
- July 2021 (1129)
- June 2021 (1088)
- May 2021 (1123)
- April 2021 (1180)
- March 2021 (1220)
- February 2021 (1136)
- January 2021 (1088)
- December 2020 (1091)
- November 2020 (1042)
- October 2020 (1161)
- September 2020 (1124)
- August 2020 (1064)
- July 2020 (1162)
- June 2020 (1104)
- May 2020 (1203)
- April 2020 (1211)
- March 2020 (1184)
- February 2020 (1071)
Recent comments
8 hours 35 min ago
8 hours 37 min ago
8 hours 38 min ago
8 hours 41 min ago
8 hours 51 min ago
8 hours 52 min ago
12 hours 43 min ago
16 hours 45 min ago
17 hours 21 min ago
19 hours 9 min ago