Transpose Date Format with Wildcards
On Monday, 11 February 2019 20:31:05 UTC, PeterAmirault wrote:
I have a 150-page Reference file where the dates are in UK format and
I'd like them in US format. Is it possible to use Wildcards to search
and replace and transpose all instances of?
I have found this online:
[0-9]{1,2} [AFJMNSOD]*
Which searches and selects the DD and MM,
I've just not figured out how to transpose the two.
1 December 2001 to December 1, 2001
1 December. to December 1.
Thanks,
Peter
--
PeterAmirault
On Monday, 11 February 2019 20:31:05 UTC, PeterAmirault wrote:
I have a 150-page Reference file where the dates are in UK format and
I'd like them in US format. Is it possible to use Wildcards to search
and replace and transpose all instances of?
I have found this online:
[0-9]{1,2} [AFJMNSOD]*
Which searches and selects the DD and MM,
I've just not figured out how to transpose the two.
1 December 2001 to December 1, 2001
1 December. to December 1.
Thanks,
Peter
--
PeterAmirault
|