RegExp date reformatting

Usage tips, posted by users. No questions here please.

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
sturner
Posts: 1
Joined: Mon Sep 13, 2004 7:39 pm

RegExp date reformatting

Post by sturner »

Given a date in YYYYMMDD form, it might be useful to be able to convert it to
MM/DD/YYYY form (as an Access import for example).

Assuming that there's no other 8 digit numbers in the file:

find: \([0-9]\{4\}\)\([0-9]\{2\}\)\([0-9]\{2\}\)
replace: \2/\3/\1
Post Reply