#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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.
|
|
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 |
This should be easy - check box | RIKIL | Mail Merge | 10 | 07-19-2011 08:03 PM |
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 |