Search found 1 match

by sturner
Mon Sep 13, 2004 7:47 pm
Forum: Tips
Topic: RegExp date reformatting
Replies: 0
Views: 1125

RegExp date reformatting

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