Page 1 of 1

Search and replace quarter dates

Posted: 07 Apr 2016 18:07
by JKC
I have several thousand imported marriage quarter dates which appear as "Mar Qtr ****" etc.
(****is the year number e.g 1851)
How can I replace these with non-text standard dates e.g Q1 1851 ?

Re: Search and replace quarter dates

Posted: 07 Apr 2016 19:27
by tatewise
See how_to:fixing_dates_date_phrases|> Fixing Dates and Date Phrases and use the Fix Date Fields plugin.

Re: Search and replace quarter dates

Posted: 08 Apr 2016 08:56
by JKC
Brilliant program! All 7000 dates changed automatically with only a handful requiring manual correction (due to typos in the original dates and not a failure of the program) Very many thanks to the author,