A very common data quality issue is when a field in a data record is populated with more than one piece of information.
Sometimes this is done as a work around, because we have a piece of information, but we haven’t a field with that distinct purpose of use. Then we find a more or less related existing field where in we can squeeze this additional piece of information.
But we also have some very common cases where this bad habit is required by external business rules or wide spread tradition.
Legal Form in Company Names
This example is examined in the post Legal Forms from Hell.
One should think that it is time for changing the bad (legal demanded) practice of mixing legal forms with company names and serve the original purpose in another more data quality friendly way.
An Address Line
An address line will typically hold a couple of elements as a street (thoroughfare) name, a house number and maybe some kind of unit identification.
By the way the order of street name and house number is opposite in approximately two equal parts of the world, with the exception of places where numbering within blocks between streets is the standard.
Education in Person Name
You can put professor in front of your name and even MBA – Master of Business Administration!! – after your name in the name field.
In the next few days I will put AFCM (Accidental Field Content Misuser) after my name.