![]()  | 
	
| 
		 
			 
			#1  
			 
			
			
			
			
		 
		
	 | 
|||
		
		
  | 
|||
| 
		
	
		
		
			
			 
			
			Hello, I timecode scripts for ADR. This requires me to go through a video and copy and paste timecodes correlating to dialogue. These timecodes are in hr:min:sec:frame format. For example,  
		
		
		
		
		
		
		
		
	
	10:01:03:20 I want to find and replace or remove the hrs: from the timecodes. Is there a way to do that in a way that won't remove any min: or sec: that are the same number? The prefix function doesn't seem to work. Thanks!  | 
| 
		 
			 
			#2  
			 
			
			
			
			
		 
		
	 | 
||||
		
		
  | 
||||
| 
		
	
		
		
			
			 
			
			You could use a wildcard Find/Replace, where: 
		
		
		
		
Code: 
	Find = [0-9]{1,2}:([0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2})
Replace = \1
				__________________ 
		
		
		
		
		
	
	Cheers, Paul Edstein [Fmr MS MVP - Word]  | 
| 
		 
			 
			#3  
			 
			
			
			
			
		 
		
	 | 
|||
		
		
  | 
|||
| 
		
	
		
		
			
			 
			
			Cool! I'll give that a shot. 
		
		
		
		
		
		
		
		
	
	I've never used wildcards before. If its not too complicated, could you (or someone else) please give me a quick run-down on what those commands mean? That would be great!  | 
| 
		 
			 
			#4  
			 
			
			
			
			
		 
		
	 | 
||||
		
		
  | 
||||
| 
		
	
		
		
			
			 
			
			The: 
		
		
		
		
• [0-9]{1,2} is any 1-2 digit number • : is simply the colon used in your time format • ( & ) tell Word to store whatever's between them • \1 says to used the first stored value (i.e. what was between the ( & )) for the replacement. For more on wildcards, see: https://wordmvp.com/FAQs/General/UsingWildcards.htm 
				__________________ 
		
		
		
		
		
	
	Cheers, Paul Edstein [Fmr MS MVP - Word]  | 
 
 | 
	
	
| 
		 | 
			 
			Similar Threads
		 | 
	||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
		
		  Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match.
	 | 
	PhillJ | Excel | 4 | 08-22-2017 03:10 AM | 
| Macro to capitalize first letter after timecode + tab | muiy | Word VBA | 1 | 06-17-2015 11:03 PM | 
		
		  Removing Styles without affecting the current format
	 | 
	capitala | Word | 3 | 12-22-2014 11:27 AM | 
		
		  Format Painter doesn't work on Table Format?
	 | 
	Joey Cheung | Word Tables | 1 | 08-20-2014 02:24 AM | 
		
		  How to add hours together
	 | 
	PomDave | Excel | 3 | 09-05-2011 04:43 AM |