title: Returning the string between the 5th and 6th Spaces in a String
body: <p>I have a column of strings that look like this:</p>
  
  <blockquote>
    <p>Target Host: dcmxxxxxxc032.erc.nam.fm.com Target Name:
    dxxxxxxgsc047.erc.nam.fm.com Filesystem /u01 has 4.98% available space
    -  fallen below warning (20) or critical (5) threshold.</p>
  </blockquote>
  
  <p>The column name is [Description]</p>
  
  <p>The substring I would like returned is (dxxxxxxgsc047.erc.nam.fm.com)</p>
  
  <p>The only consistency in this data is that the desired string occurs between the 5th and 6th occurrences of spaces " " in the string, and after the phrase "Target Name: "  The length of the substring varies, but it always ends in another " ", hence my attempt to grab the substring between the 5th and 6th spaces.</p>
  
  <p>I have tried </p>
  
  <pre><code>MID([Description],((FIND([Description],"Target Name: "))+13),FIND([Description]," ",((FIND([Description],"Target Name"))+14)))
  </code></pre>
  
  <p>But that does not work.</p>
  
  <p>(Edit: We use Tableau 8.2, the Tableau 9 only functions can't be part of the solution, thanks though!)</p>
  
  <p>Thank you in advance for your help.</p>