How to Extract Contents between Two Specific Words from One Word Document to Another

In this article, we will show you the way to extract contents between two specific words from one Word document to another.Extract Contents between Two Specific Words from One Word Document to Another

Now and then, you will have to extract contents between specific words on some occasions. Following are 2 possible cases you can run into:

  1. First, in a Word table, for all cells in a column beginning and ending with the same 2 words, you may need to extract just the different middle part, such as bellow:   Extract Table Contents
  2. Second, in some log files with multiple entries, you will probably need to extract just the ones you need. Then you can specify the first and last word and use method I this article to get contents you need.

To accomplish such a task, we prefer to run a Word macro. Just follow these steps.

Extract Contents between Two Words

  1. First and foremost, press “Alt+ F11” to open VBA editor in Word.
  2. Next click “Normal” project on the left column.
  3. Then click “Insert” tab on the menu bar.
  4. Choose “Module” from the drop-down menu.Click "Normal"->Click "Insert"->Click "Module"
  5. Double click to enter the coding space of the new module and paste these codes there:
Sub ExtractContentsBetweenTwoWords()
  Dim strFirstWord As String
  Dim strLastWord As String
  Dim objDoc As Document
  Dim objDocAdd As Document
  Dim objRange As Range
 
  ' Initialize and create a new blank document.
  Set objDoc = ActiveDocument
  Set objDocAdd = Documents.Add
  objDoc.Activate
 
  ' Enter the first and last words.
  strFirstWord = InputBox("Enter the first word:", "First Word")
  strLastWord = InputBox("Enter the last word:", "Last Word")
 
  ' Find and extract contents and insert them into the new document.
  With Selection
    .HomeKey Unit:=wdStory
    With Selection.Find
      .ClearFormatting
      .Text = strFirstWord & "*" & strLastWord
      .MatchWildcards = True
      .MatchWholeWord = True
 
      Do While .Execute
        Selection.MoveStart Unit:=wdCharacter, Count:=Len(strFirstWord)
        Selection.MoveEnd Unit:=wdCharacter, Count:=-Len(strLastWord)
 
        objDocAdd.Range.InsertAfter Selection.Range & vbNewLine
        Selection.Collapse wdCollapseEnd
      Loop
    End With
  End With
End Sub
  1. Next click “Run” or hit “F5” to execute codes.Paste Codes->Click "Run"
  2. In the “First Word” input box, enter the first word. Remember the macro is case sensitive. So initialize the word if necessary.
  3. Then click “OK” to go to the “Last Word” box.Enter the First Word->Click "OK"
  4. Similarly, enter word and click “OK”. Don’t forget to follow the same rule of initializing word according.

There will be a new document open and all contents extracted shall appear there.Extract Contents between 2 Words

Extract Contents in Brackets

As we’ve mentioned, some contents are in brackets. Then here is what you can do:

  1. To start off, you need to follow steps above as to install and run a macro.
  2. Now according to the type of a bracket, you can choose corresponding macro below:

For braces {}:

Sub ExtractContentsInBraces()
  Dim objDoc As Document
  Dim objDocAdd As Document
  Dim objRange As Range
 
  Set objDoc = ActiveDocument
  Set objDocAdd = Documents.Add
  objDoc.Activate
 
  With Selection
    .HomeKey Unit:=wdStory
    With Selection.Find
      .ClearFormatting
      .Replacement.ClearFormatting
      .Text = "\{(*)\}"
      .MatchWildcards = True
 
      Do While .Execute
        Selection.MoveStart Unit:=wdCharacter, Count:=1
        Selection.MoveEnd Unit:=wdCharacter, Count:=-1
 
        objDocAdd.Range.InsertAfter Selection.Range & vbNewLine
        Selection.Collapse wdCollapseEnd
      Loop
    End With
  End With
End Sub
  1. For square brackets [ ]:

Just replace this code line:

.Text = "\{(*)\}"

With:

.Text =\[(*)\]
  1. Then for Parentheses():

Replace the same code line in step 3 with:

.Text = "\((*)\)"
  1. And for Angle Brackets<>:

Use this line instead:

.Text = "\<(*)\>"

Handle a Data Disaster

In a highly connected Word as ours, it’s vital to keep the safety of data in mind all the time. What’s more, one must have to know what to do in times of a data disaster. And your best choice is to get a docx repair tool.

Author Introduction:

Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including xls recovery and pdf repair software products. For more information visit www.datanumen.com

Comments are closed.