-Emphasis- As an additional thought, does your questioner want to identify those remaining names where there really is only a middle initial, or no middle name at all, as opposed to people with missing parts to their name? -End-
Actually, I simplified that question. She wants to make a list of people in her database of people who are alive, but she does not know the middle name for. By "alive" she means no death date. I can make a list of people for her who is alive; that part is easy. (Just search for those with an entered death date, tag those, and the names that are not tagged are the ones who are alive.) Then, from that list, I have been trying to determine an easy way for her to narrow down what she is looking for. She does *not* want the names of: Joe William Brown John Mark David Doe Denise Karen Fairchild To be in the list. She knows all three (or more) names for that person. She does want the following people listed for example: Joy D. Anderson Frank Davidson G. Adams J. W. Bigshot Those she would like to call or write and try to get the full names. Hope this helps. Thank you. Robert -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jennie Goodwin Sent: 2006-06-05 16:39 To: [email protected] Subject: Re: [LegacyUG] Searching for people without a known complete middle name? Robert: As an additional thought, does your questioner want to identify those remaining names where there really is only a middle initial, or no middle name at all, as opposed to people with missing parts to their name? That might prevent additional work if he or she runs this list every year or so. I have a distant cousin with three kids, one with a middle name, one with a middle initial, and one with no middle name at all. As I recall, this was discussed on the list several months ago. Ths US military requires a "payroll signature" of the form "George W. Bush." Our friend John Doe would have to sign as "John (NMI) Doe, as in No Middle Initial. >From the earlier discussion, his friend John Q Public apparently would have to sign "John Q (IO) Public, as Initial Only. I don't remember if anyone had a suggestion on how to record this so that the name on the Individual screen was correct, but letting readers know that this individual did in fact not have a middle name, or had just an initial, so later readers wouldn't spend research time trying to find a name that wasn't there. Jennie --- Robert Carneal <[EMAIL PROTECTED]> wrote: > I was asked to demo how to make a list of names in > the family file, and from > that list, take out everyone with a first name, > known *full* middle name, > and last name. That is, the names that remain would > be of those without a > middle name and/or only the middle initial is known. > In Legacy, I don't know > of a way to do this- the first name and middle name > go in the same field. > > However, I can do this nonetheless by opening the > file in GenViewer, list > the RINs and then list the names by Surname, Given > Name. Use GenViewer to > save and paste that into a spreadsheet, and have the > spreadsheet perform a > "text to columns" function. That is, if B2 has > Alexander Richard Craven, > then the name gets split into three columns with B2 > holding Alexander, C2 > holds Richard, and D2 holds Craven. > > If B3 has Doe, John, then this feature breaks the > name into B3= Doe, C3 = > John, and nothing in D3. > > Sort by column D, then C, and then by B. Remove all > the rows for which > column D in the row is NOT empty. Then what remains > is a list of people for > whom you do not know the middle names. > > My question: Is there a better way to do this? > > Thank you. > > Robert > > Legacy User Group guidelines can be found at: > http://www.LegacyFamilyTree.com/Etiquette.asp > > To find past messages, please go to our searchable > archives at: > http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ > > For online technical support, please visit > http://www.legacyfamilytree.com/Help.asp > > To unsubscribe please visit: > http://www.legacyfamilytree.com/LegacyLists.asp > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ For online technical support, please visit http://www.legacyfamilytree.com/Help.asp To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ For online technical support, please visit http://www.legacyfamilytree.com/Help.asp To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
