Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- - Open 'CBT Nugget Transcript.csv' with NotePad++
- - Note how many lines you've got, it should remain the same throughout the whole process.
- - Replace #EANF# with nothing
- - Replace " with nothing
- - Replace , with ' ' (SPACE)
- - Replace ' {2,}' with ' ' using RegEx (NO '. matched newline')
- - Save, Profit!
- 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++.
- To copy the script of a video :
- - Get the video number
- - GoTo the corresponding line in 'CBT Nugget Transcript.csv'
- - Copy the line as a whole
- - Paste on YouTube
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement