Page 1 of 1

Query to find date phrases

Posted: 20 Jan 2010 05:35
by RandyP
All I've used as far as queries go are the ones provided from the menu, so I'm not sure how to go about this.

After a recent merge of two GEDCOMS, I've run across the odd date phrase problem where quotation marks are enclosing a FULL date (e.g., '1 Apr 1900') when it should be 1 Apr 1900.

I've fixed the few I've found, but is there a way to run a query to search for date phrases like the one illustrated above without having to put in the exact date, by using a wildcard symbol of some sort?



ID:4295

Query to find date phrases

Posted: 20 Jan 2010 07:14
by Jane
The quickest way is to use a fact query like

Add if %FACT.DATE:YEAR% is null
Exclude if %FACT.DATE% is null

This will list all facts where the year is not known so will include dates where bef or frm is used as well as your phrases, but it will also list all the date phrases as well.

I suspect you could also use a =text qualifier to the look for ' in the date field, but I have not tried it this morning.

Query to find date phrases

Posted: 20 Jan 2010 07:33
by RandyP
I have no idea how to run a non-standard query. I'll have to come back to this once I learn about custom queries.

It really gets frustrating when you're required to program things yourself, heh.

Thanks anyways.

Edit: Nevermind, I used the standard query 'All Facts', and went from there, fixing each individual record.

Query to find date phrases

Posted: 20 Jan 2010 08:09
by Jane
Building queries is pretty simple once you get over the start.

There is a simple example in the How Tos [wiki]how_to:index[/wiki]