* Query to find date phrases

[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

[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.

[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.

[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]