Glossary

Empty string

Text that was recorded and is empty (""). Not the same as missing.

An empty string is a value. Rules often convert blanks to missing after trimming, so that " " doesn't match other blanks in a join. Do this only where a rule says so.

Lesson: Missing is not empty (and neither is zero)

Related: Missing value (null), Trim