title: effective method for text mining in vba/excel
body: <p>I have a huge text file, consisting of about 18.000 samples of text, seperated by a consistent number of forward slaches: ////////////////////</p>
  
  <pre><code>Example:
  
  ////////////////////
  P11/000568
  
  name: john
  age: 18
  hobbies: cycling, drawing
  
  ////////////////////
  P12/000894
  name: eva
  age: 19
  hobbies: football, soccer, baseball
  </code></pre>
  
  <p>I want to "mine" this text file for the word "soccer", so that every time the program "sees" this word, a new line is created in excel, containing the name of the subject and the code above</p>
  
  <pre><code>      A            B           age
  1 P12/000894       eva         19
  </code></pre>
  
  <p>I have tried some code (vba- excel, reading in every chunk of text into an array) but since the txt file is so large, my pc is melting when running the code.
  Any ideas on the best method (vba-excel preferentially, powerpivot/powerquery??)</p>
  
  <p>Thanks
  C</p>