title: How to extract text within a string of text
body: <p>I have a simple problem that I'm hoping to resolve without using VBA but if that's the only way it can be solved, so be it. </p>
  
  <p>I have a file with multiple rows (all one column). Each row has data that looks something like this:</p>
  
  <p>1   7.82E-13   >gi|297848936|ref|XP_00| 4-hydroxide gi|297338191|gb|23343|randomrandom</p>
  
  <p>2   5.09E-09   >gi|168010496|ref|xp_00| 2-pyruvate</p>
  
  <p>etc...</p>
  
  <p>What I want is some way to extract the string of numbers that begin with "gi|" and end with a "|". For some rows this might mean as many as 5 gi numbers, for others it'll just be one. </p>
  
  <p>What I would hope the output would look like would be something like:</p>
  
  <p>297848936,297338191</p>
  
  <p>168010496</p>
  
  <p>etc...</p>