Advertisement
ikostello

Netflix Originator exported text to text without subtitle numbers and caret signs in Word

Aug 21st, 2020 (edited)
2,355
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub Fridge2text()
  2. '
  3. ' Fridge2text Macro
  4. '
  5. '
  6.    Selection.Find.ClearFormatting
  7.     Selection.Find.Replacement.ClearFormatting
  8.     With Selection.Find
  9.         .Text = "^13^13[0-9]{1,}^13"
  10.         .Replacement.Text = " "
  11.         .Forward = True
  12.         .Wrap = wdFindContinue
  13.         .Format = False
  14.         .MatchCase = False
  15.         .MatchWholeWord = False
  16.         .MatchWildcards = True
  17.         .MatchSoundsLike = False
  18.         .MatchAllWordForms = False
  19.     End With
  20.     Selection.Find.Execute Replace:=wdReplaceAll
  21.     With Selection.Find
  22.         .Text = "^13"
  23.         .Replacement.Text = " "
  24.         .Forward = True
  25.         .Wrap = wdFindContinue
  26.         .Format = False
  27.         .MatchCase = False
  28.         .MatchWholeWord = False
  29.         .MatchWildcards = True
  30.         .MatchSoundsLike = False
  31.         .MatchAllWordForms = False
  32.     End With
  33.     Selection.Find.Execute Replace:=wdReplaceAll
  34. End Sub
  35.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement