LXer: How to do a both/neither/one/other tally
by LXer from LinuxQuestions.org on (#5729C)
Published at LXer:
A routine check I do on data tables is to see if paired fields are either both filled or both empty in each record. By "paired fields" I mean, for example, a latitude field and a longitude field. It doesn't make much sense to have a latitude without a longitude, or vice versa! The command described here will tally up the "both filled", "both empty", "only the first filled" and "only the second filled" entries.
Read More...
A routine check I do on data tables is to see if paired fields are either both filled or both empty in each record. By "paired fields" I mean, for example, a latitude field and a longitude field. It doesn't make much sense to have a latitude without a longitude, or vice versa! The command described here will tally up the "both filled", "both empty", "only the first filled" and "only the second filled" entries.
Read More...