title: select string between 3rd and 4th pipe delimiter
body: <p>I have a column that contains values such as </p>
  
  <pre><code>Column
  Asset|Class1|Category1|Group1|Account1
  Expense|Class23|Category23|Group23|Account23
  </code></pre>
  
  <p>I want to select the string between 3rd and 4th occurrence of my pipe delimiter, how can I achieve this?</p>
  
  <p>I've tried the PARSENAME and charindex+stuff function, but they have limitations, like max 128 characters. Also our SQL server has limited regex support. Any ideas?</p>
  
  <p>SELECT REVERSE(PARSENAME(REVERSE(replace(LTRIM(Column), '|', '.')), 3))</p>
  
  <p>My select need to return:
  Group1
  Group23</p>