Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-28-2016, 09:46 AM
Marrick13 Marrick13 is offline Regex/wildcard search for dates with 2-digit and 4-digit years Windows XP Regex/wildcard search for dates with 2-digit and 4-digit years Office 2010 32bit
Competent Performer
Regex/wildcard search for dates with 2-digit and 4-digit years
 
Join Date: Jun 2006
Posts: 103
Marrick13 will become famous soon enough
Default Regex/wildcard search for dates with 2-digit and 4-digit years

I have been working with the attached code to see if I can get it to search and format dates in Word. I am trying to get it to search for a variety of formats, and having some success with a wildcard search. But I’m stuck on searching the format ‘9/25/2014’.

The wildcard expression I’m using for this, "([0-9]{1,2})(/)([0-9]{1,2})(/)([0-9]{2})", finds both dates with 2- and 4-digit years. The code highlights '9/25/20’ and ignores the ‘14’ (as it should because of the {2}), but I want to find a way to have it search ONLY for dates with 2-digit years, instead of reading only the first 2 digits of 4-digit years. Been trying other wildcard switches but nothing achieves this specific search.

Can I get some help? Code is in the attached.
Attached Files
File Type: txt Format_All_Dates.txt (771 Bytes, 9 views)
Reply With Quote
 

Tags
date, regex, search and replace



Similar Threads
Thread Thread Starter Forum Replies Last Post
Regex/wildcard search for dates with 2-digit and 4-digit years A challenging digit by digit manipulation, rotate the digit in range of 0 to 9 laucn Excel Programming 14 05-17-2015 12:12 PM
Regex/wildcard search for dates with 2-digit and 4-digit years Outlook export to a calendar csv file is transposing single digit starting dates sala-marie Excel 3 10-27-2013 09:32 PM
Regex/wildcard search for dates with 2-digit and 4-digit years Recipient counter in Mail Merge Wizard displays only one digit in Word Liuneddu Word 1 08-13-2013 03:57 AM
Regex/wildcard search for dates with 2-digit and 4-digit years Import contact from EXCEL to Outlook (no zero in left side digit) nmo111 Outlook 1 05-28-2010 11:00 AM
Dividing merge cell into ten equal rectangles for inputing Digit? aligahk06 Excel 0 05-12-2010 06:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft