Closed AnneMTreasure closed 2 years ago
Used gsub
to replace "na na na" for the instances where people have correctly put na for all three of the surname, first name and title for all record types where applicable.
However, there are other possibilities that may need to be accounted for, e.g. "na na" (title question is not mandatory), or na entered incorrectly (e.g. NA), or na entered for the title and not the names (e.g. the end result output - na John Smith), or na entered for one of the names (e.g. Mr na Smith).
If this starts occurring, then the scripts will have to be written to account for it.
Shiny tables (e.g. see project): fix 'na na na' for contact name if no name entered