* Query for individuals with initials and missing full names

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
avatar
AndrewEllis
Platinum
Posts: 36
Joined: 02 Jun 2015 09:27
Family Historian: V7

Query for individuals with initials and missing full names

Post by AndrewEllis »

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
User avatar
tatewise
Megastar
Posts: 28341
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Query for individuals with initials and missing full names

Post by tatewise »

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.
Attachments
Individual Name Initials.fhq
(2.3 KiB) Downloaded 47 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
AdrianBruce
Megastar
Posts: 2090
Joined: 09 Aug 2003 21:02
Family Historian: V7
Location: South Cheshire
Contact:

Re: Query for individuals with initials and missing full names

Post by AdrianBruce »

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:
His 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
See https://en.wikipedia.org/wiki/Harry_S._Truman
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
User avatar
LornaCraig
Megastar
Posts: 3190
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Query for individuals with initials and missing full names

Post by LornaCraig »

... 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 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.
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.
Lorna
User avatar
tatewise
Megastar
Posts: 28341
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Query for individuals with initials and missing full names

Post by tatewise »

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
avatar
AndrewEllis
Platinum
Posts: 36
Joined: 02 Jun 2015 09:27
Family Historian: V7

Re: Query for individuals with initials and missing full names

Post by AndrewEllis »

Thanks, yes I was being a bit mischievous in my examples!

Great trivia questions!

Andrew
User avatar
tatewise
Megastar
Posts: 28341
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Query for individuals with initials and missing full names

Post by tatewise »

Does the Query do what you wanted?
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
LornaCraig
Megastar
Posts: 3190
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Query for individuals with initials and missing full names

Post by LornaCraig »

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
User avatar
tatewise
Megastar
Posts: 28341
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Query for individuals with initials and missing full names

Post by tatewise »

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
avatar
AndrewEllis
Platinum
Posts: 36
Joined: 02 Jun 2015 09:27
Family Historian: V7

Re: Query for individuals with initials and missing full names

Post by AndrewEllis »

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
avatar
AndrewEllis
Platinum
Posts: 36
Joined: 02 Jun 2015 09:27
Family Historian: V7

Re: Query for individuals with initials and missing full names

Post by AndrewEllis »

Thanks Mike

It worked a dream and picked up all the cases in my database

Andrew
avatar
AndrewEllis
Platinum
Posts: 36
Joined: 02 Jun 2015 09:27
Family Historian: V7

Re: Query for individuals with initials and missing full names

Post by AndrewEllis »

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
Post Reply