Browse Ask a Question
 
Tools Add
Rss Categories

Converting RTF to TC transcript for CPC

Author: Reference Number: AA-00405 Views: 3852 Created: 2012-04-16 10:51 Last Updated: 2015-01-09 12:25 0 Rating/ Voters

 

 

      1.       Delete top Header

2.       Use Find and Replace (check wildcard checkbox) to remove the caption number ([0-9]{4}) “code + space”  with  nothing. 

3.       Use Find and Replace (check wildcard checkbox)  to remove the  duration (\(??:??\))”space + code” with nothing.

4.       Replace < with nothing. (uncheck wildcard checkbox)

5.       If <NNN > is used Replace > with nothing.

6.       Replace ‘  with XXX

7.       Replace  ^p^p with ZZZ

8.       Replace ^p with ^t

9.       Replace ZZZ with ^p

10.   Replace space space with space.

11.   Replace space? with ?

12.   Replace space! with!

13.   Replace space] with]

14.   Replace space[ with[

15.   Save as Plain TXT document with Unicode UTF 8 encoding.

 

 

Excel

1.       Bring into Excel as Fixed

2.       Have only three columns

3.       Change all three column’s  formatting to Text

4.       Replace XXX with ‘

5.       Replace “ with QQQ

6.       Save as delimited

7.        

 

 

UTF 8 & encoding

 

Notepad

1.       Replace “ with nothing

2.       Replace QQQ with “

3.       Save

 

Test by import into CPC


Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below:
Info Ask a Question