Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2017, 01:01 PM
pirwin pirwin is offline Removing hours in a timecode format Windows 10 Removing hours in a timecode format Office 2013
Novice
Removing hours in a timecode format
 
Join Date: Aug 2017
Posts: 4
pirwin is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 11-24-2017, 04:19 PM
macropod's Avatar
macropod macropod is offline Removing hours in a timecode format Windows 7 64bit Removing hours in a timecode format Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 11-24-2017, 10:47 PM
pirwin pirwin is offline Removing hours in a timecode format Windows 10 Removing hours in a timecode format Office 2013
Novice
Removing hours in a timecode format
 
Join Date: Aug 2017
Posts: 4
pirwin is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 11-24-2017, 11:52 PM
macropod's Avatar
macropod macropod is offline Removing hours in a timecode format Windows 7 64bit Removing hours in a timecode format Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing hours in a timecode format 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 hours in a timecode format Removing Styles without affecting the current format capitala Word 3 12-22-2014 11:27 AM
Removing hours in a timecode format Format Painter doesn't work on Table Format? Joey Cheung Word Tables 1 08-20-2014 02:24 AM
Removing hours in a timecode format How to add hours together PomDave Excel 3 09-05-2011 04:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:09 PM.


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