Advertisement
TheDemystifier

Format CBTNuggets Transcript

Jul 9th, 2017
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Smarty 0.66 KB | None | 0 0
  1. - Open 'CBT Nugget Transcript.csv' with NotePad++
  2. - Note how many lines you've got, it should remain the same throughout the whole process.
  3. - Replace #EANF# with nothing
  4. - Replace " with nothing
  5. - Replace , with ' ' (SPACE)
  6. - Replace ' {2,}' with ' ' using RegEx (NO '. matched newline')
  7. - Save, Profit!
  8.  
  9. NOTE: Do NOT use the script from Excel, as it has a limit of 32,767 chars per cell, so if you decide to use Excel, make sure the number of lines is the same as in Notepad++. Or use Notepad++.
  10.  
  11. To copy the script of a video :
  12. - Get the video number
  13. - GoTo the corresponding line in 'CBT Nugget Transcript.csv'
  14. - Copy the line as a whole
  15. - Paste on YouTube
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement