* Query for individuals with initials and missing full names
-
- Platinum
- Posts: 36
- Joined: 02 Jun 2015 09:27
- Family Historian: V7
Query for individuals with initials and missing full names
Sorry for such a basic query question, but I'm trying to clean up my database by creating a list of individuals who are missing their full name and for whom I only have their initials, so people like Harry S. Truman or J. K. Rowling for example.
For some of them I've entered the initials followed by a full stop (.) and for others just their initials separated by a space.
Is there any easy way to do this please?
Many thanks
Andrew
For some of them I've entered the initials followed by a full stop (.) and for others just their initials separated by a space.
Is there any easy way to do this please?
Many thanks
Andrew
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Query for individuals with initials and missing full names
Andrew, try the attached Individual Name Initials Query.
That relies on the new FH V7 functions =Section(...) and =TextLen(...)
=Section(...) allows sections of Name separated by spaces to be extracted.
=TextLen(...) allows those sections to be tested for their length.
Currently, it only checks Primary Name fields INDI.NAME[1] but could be extended to Alternate Names INDI.NAME[2], etc.
That relies on the new FH V7 functions =Section(...) and =TextLen(...)
=Section(...) allows sections of Name separated by spaces to be extracted.
=TextLen(...) allows those sections to be tested for their length.
Currently, it only checks Primary Name fields INDI.NAME[1] but could be extended to Alternate Names INDI.NAME[2], etc.
- Attachments
-
- Individual Name Initials.fhq
- (2.3 KiB) Downloaded 47 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- AdrianBruce
- Megastar
- Posts: 2107
- Joined: 09 Aug 2003 21:02
- Family Historian: V7
- Location: South Cheshire
- Contact:
Re: Query for individuals with initials and missing full names
Just as an aside - I'm guessing that Harry S Truman was listed simply as an example of an initialled name that came to mind but in his case the "S" is just "S", it isn't short for anything - when I checked that in Wikipedia, I found an explanation that I'd not seen before:
So if any of you find such a "name" in that locality, this may be the explanation.
PS - there is then a whole debate as to whether the "S" should be followed by a full stop!
See https://en.wikipedia.org/wiki/Harry_S._TrumanHis middle initial, "S", is not an abbreviation of one particular name, but rather honors both his grandfathers, Anderson Shipp Truman and Solomon Young, a semi-common practice in the American South
So if any of you find such a "name" in that locality, this may be the explanation.
PS - there is then a whole debate as to whether the "S" should be followed by a full stop!
Adrian
- LornaCraig
- Megastar
- Posts: 3201
- Joined: 11 Jan 2005 17:36
- Family Historian: V7
- Location: Oxfordshire, UK
Re: Query for individuals with initials and missing full names
... and if you'd looked a bit further in Wikipedia, Adrian, you would have found a similar explanation about the OP's other example:
Although K stands for Kathleen, after her grandmother, I don't think she is ever known as Joanne Kathleen Rowling. I would record her as Joanne Rowling, with an alternate name of J K Rowling.Although she writes under the pen name J. K. Rowling, before her remarriage her name was Joanne Rowling, or Jo. At birth, she had no middle name. Staff at Bloomsbury Publishing asked that she use two initials rather than her full name, anticipating that young boys – their target audience – would not want to read a book written by a woman. She chose K (for Kathleen) as the second initial of her pen name, from her paternal grandmother, and because of the ease of pronunciation of two consecutive letters.
Lorna
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Query for individuals with initials and missing full names
I suspect Andrew just chose those names as random examples and it is coincidental that they both have an initial that does not expand to a forename.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
-
- Platinum
- Posts: 36
- Joined: 02 Jun 2015 09:27
- Family Historian: V7
Re: Query for individuals with initials and missing full names
Thanks, yes I was being a bit mischievous in my examples!
Great trivia questions!
Andrew
Great trivia questions!
Andrew
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Query for individuals with initials and missing full names
Does the Query do what you wanted?
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- LornaCraig
- Megastar
- Posts: 3201
- Joined: 11 Jan 2005 17:36
- Family Historian: V7
- Location: Oxfordshire, UK
Re: Query for individuals with initials and missing full names
Andrew's "mischievous" examples serve a good purpose. (I think it was intentional, Mike). The point is that sometimes the initial is all there is.
Lorna
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Query for individuals with initials and missing full names
I thought their purpose was as examples of the kinds of names with initials that he wanted a Query to list and I provided that Query.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
-
- Platinum
- Posts: 36
- Joined: 02 Jun 2015 09:27
- Family Historian: V7
Re: Query for individuals with initials and missing full names
Sorry Mike
Should have thanked you for your prompt reply - am on lunch at work, so will have to check tonight, and yes Lorna the examples were deliberately chosen for the reasons you've all spotted!
Many thanks again
Andrew
Should have thanked you for your prompt reply - am on lunch at work, so will have to check tonight, and yes Lorna the examples were deliberately chosen for the reasons you've all spotted!
Many thanks again
Andrew
-
- Platinum
- Posts: 36
- Joined: 02 Jun 2015 09:27
- Family Historian: V7
Re: Query for individuals with initials and missing full names
Thanks Mike
It worked a dream and picked up all the cases in my database
Andrew
It worked a dream and picked up all the cases in my database
Andrew
-
- Platinum
- Posts: 36
- Joined: 02 Jun 2015 09:27
- Family Historian: V7
Re: Query for individuals with initials and missing full names
Thanks again Mike,
Just checking for the middle initials is throwing up additional record matches on Ancestry and Find My Past which are showing additional marriages that are clearly right for my family tree that I was unaware of. Some of this work is showing up individuals I had previously recorded who occasionally used their middle name as their main name, and is helping identify some duplicate individuals
I had a similar lot of research leads when looking at witnesses to marriages some time ago.
Best wishes
Andrew
Just checking for the middle initials is throwing up additional record matches on Ancestry and Find My Past which are showing additional marriages that are clearly right for my family tree that I was unaware of. Some of this work is showing up individuals I had previously recorded who occasionally used their middle name as their main name, and is helping identify some duplicate individuals
I had a similar lot of research leads when looking at witnesses to marriages some time ago.
Best wishes
Andrew