Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2013, 01:01 PM
patatesboy patatesboy is offline I need help finding a easy way to do this Windows 8 I need help finding a easy way to do this Office 2010 64bit
Novice
I need help finding a easy way to do this
 
Join Date: Jan 2013
Posts: 1
patatesboy is on a distinguished road
Default I need help finding a easy way to do this

Hello, I am new here, and hopefully someone here will be able to answer my question. I have this project that I am working on, and it is taking forever to try and complete. Basically, I have a bunch of long documents, they are transcripts of multiple people talking. I basically have to remove everyone's transcripts except for one person.

So With the example of the types of documents I'm working on below. I have to keep the same format, as far as the tape title and start to end timecodes, I have to delete what anyone says except for AA. Is there a way of accomplishing this via running a script? I have tons of files like this and theyre about 84 pages each document.

This is what they look like, and if you scroll down Ill post what its supposed to look like just in case my description of my problem isn't great.

[TAPE: 00001 - (99)]
Start 18:07:36;19 - End 18:07:47;27



AA: Hello, how are you sir.

BB: I’m doing great thank you.
--------------------------------
[TAPE: 00001 - (100)]
Start 18:07:47;28 - End 18:07:49;11

AA: Hey don’t do that!

BB: I’m sorry I didn’t mean to.
--------------------------------
[TAPE: 00001 - (101)]
Start 18:07:49;12 - End 18:07:55;11

AA: Did you catch American Idol last night?

BB: Yes.
--------------------------------
[TAPE: 00001 - (102)]
Start 18:07:55;12 - End 18:08:10;15

AA: I need to go to get something to eat, would you like to go with me?

CC: Yes, let’s go.
--------------------------------
[TAPE: 00001 - (103)]
Start 18:08:10;16 - End 18:08:13;25

AA: But he has to definitely give me a good price.

CC: We’ll cut you a very good deal.



And this is what it is supposed to look like.

[TAPE: 00001 - (99)]
Start 18:07:36;19 - End 18:07:47;27

AA: Hello, how are you sir.

--------------------------------
[TAPE: 00001 - (100)]
Start 18:07:47;28 - End 18:07:49;11

AA: Hey don’t do that!

--------------------------------
[TAPE: 00001 - (101)]
Start 18:07:49;12 - End 18:07:55;11

AA: Did you catch American Idol last night?

--------------------------------
[TAPE: 00001 - (102)]
Start 18:07:55;12 - End 18:08:10;15

AA: I need to go to get something to eat, would you like to go with me?

--------------------------------
[TAPE: 00001 - (103)]
Start 18:08:10;16 - End 18:08:13;25

AA: But he has to definitely give me a good price.


Thanks in advance. Even if there is no way of doing this please reply.
Reply With Quote
  #2  
Old 01-18-2013, 10:02 PM
How Can I? How Can I? is offline I need help finding a easy way to do this Windows 7 64bit I need help finding a easy way to do this Office 2007
Novice
 
Join Date: Jan 2013
Posts: 4
How Can I? is on a distinguished road
Default Excel

Actually, I think you would be better off cutting and pasting that into EXCEL and striping it down there. - Sad thing is, I don't know enough about excel to tell you HOW to do it. But there are a lot of Excel forums out there that could. - Just a though.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
i need some help with Access 2010 very easy napninjax Misc 0 09-15-2011 03:32 PM
I need help finding a easy way to do this This should be easy - check box RIKIL Mail Merge 10 07-19-2011 08:03 PM
I need help finding a easy way to do this Easy questions for VBA programmer regarding Word Templates gurp99 Word VBA 1 06-24-2011 06:26 PM
Three easy (certainly for experts!) Word-questions cindymiller Word 3 12-26-2010 02:18 AM
I need help creating an extra column EASY question :) Please soapage Word 2 03-16-2009 05:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:50 AM.


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