#1
|
|||
|
|||
Removing hours in a timecode format
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 |