TMG-L Archives

Archiver > TMG > 2010-10 > 1287944371


From: "Michael J. Hannah" <>
Subject: Re: [TMG] Wish list
Date: Sun, 24 Oct 2010 12:19:31 -0600
References: <mailman.724.1287903680.21322.tmg@rootsweb.com>
In-Reply-To: <mailman.724.1287903680.21322.tmg@rootsweb.com>


On 10/24/2010 David Ball asked:
> ... it would be nice to have wild cards ...
> so I can find couples with variant spellings
> and a range of birth years

TMG already has search operators for this. For names, (see TMG Help
topics "Picklist Filter", "Filter the Project Explorer") you can use the
Windows standard wildcard characters of '*' and '?' for variant
spellings when you use the "LIKE" operator. [There have been some
reported cases where this does not seem to work and have been reported
as bugs, but try it anyway.]

? - The ? will match any one character.
For example, H?T will match "hat" or "hot" or "hut".

* - The * will match any string of characters.
For example, MER* will match Merry, Merriment, Merrimac, etc.

There is the operator "Is between" where you can give two character
values separated by a comma; for example, "GivenName Is Between A,C" or
"Surname Is Between SA,SE"

You can even use operators such as <> (not equal), >= (greater than or
equal to), <= (less than or equal to), > (greater than), and < (less
than) when searching for names. (See the TMG Help topic "Search the
Project Explorer") For example, let's say you would like to look at
every person in a data set or project whose name is Eliza. But you don't
want to have to sift through all the Elizabeths too. You can't say
GivenName = Eliza because that would miss all of the Elizas who have a
middle name or initial. You can't say GivenName Contains Eliza because
that would also give you the Elizabeths. But you can set search criteria
for:

GivenName >= Eliza
GivenName < Elizabeth

Range operators are also available for birth years. For examples see
the TMG Help topic "Filter and Accent Examples".

Michael

This thread: