Hello. Suppose in field ObitTxt$ I have something like:
John William Doe, of 2004 North 11 Street, died yesterday June 22, 2004. He was a member of the Walnut Baptist Church. July 8th 1967, he was married to Kathy Wilson. (and so on.)
I see several ways to have dates. They can be in format of:
MMM Dd, YYYY
MM-DD-YYYY
YYYY-MMM-DD
YYYY-MM-DD
and so on.
Does anyone know of a tested method for extracting the date no matter the format? My first thought was to simply look for a 4-digit number and extract that as the date, but that gets foiled when the obit includes a home address. Plus, when more than one date is in the obit, it could be confusing.
Any ideas? I am hoping someone else has run into this one before.
Thanks.
Robert
------------------
John William Doe, of 2004 North 11 Street, died yesterday June 22, 2004. He was a member of the Walnut Baptist Church. July 8th 1967, he was married to Kathy Wilson. (and so on.)
I see several ways to have dates. They can be in format of:
MMM Dd, YYYY
MM-DD-YYYY
YYYY-MMM-DD
YYYY-MM-DD
and so on.
Does anyone know of a tested method for extracting the date no matter the format? My first thought was to simply look for a 4-digit number and extract that as the date, but that gets foiled when the obit includes a home address. Plus, when more than one date is in the obit, it could be confusing.
Any ideas? I am hoping someone else has run into this one before.
Thanks.
Robert
------------------
Comment