Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2014, 05:23 AM
macropod's Avatar
macropod macropod is offline How can I tag and selectively extract text (multiple files)? Windows 7 64bit How can I tag and selectively extract text (multiple files)? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Based on your description, the basic manual approach would be to
1. use a wildcard Find/Replace, where:
Find = (\[[0-9]{2}:[0-9]{2}:[0-9]{2}\])^32([A-Z]{2})^32
Replace = \1^t\2^t
2. Select the whole document and use Insert|Table>Convert Text To Table, to convert the document into a 3-column table
3. Sort the table by the 2nd column.
4. In column 3, select all the rows for a set of initials in column 2, then check the word count stats on the Word status bar.



Does the above do the job? If so a macro can be used to automate the process, but what kind of output do you want - and where?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
format style, transcriptions, word count by speaker



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I tag and selectively extract text (multiple files)? how to selectively highlight text in word cnyoon2 Word 1 08-04-2015 08:16 AM
How can I tag and selectively extract text (multiple files)? Importing multiple text files and getting certain figures. X82 Excel Programming 1 09-26-2012 09:29 PM
How can I tag and selectively extract text (multiple files)? VBA code to extract specific bookmarks from multiple word files Rattykins Word VBA 4 06-27-2012 10:02 PM
How can I tag and selectively extract text (multiple files)? how to extract wav files from ppts t-4-2 PowerPoint 2 01-19-2012 02:24 AM
How can I tag and selectively extract text (multiple files)? Copying multiple files as text without extensions Metamag Office 3 05-09-2011 06:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:35 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