title: Split Row by X instance of a delimiter power query
body: <p>I have the following data which I wish to split as follows:</p>
  <p><a href="https://i.stack.imgur.com/N5cF2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N5cF2.png" alt="enter image description here" /></a></p>
  <p>The condition here is that it splits on the first instance of <code>@</code> provided 2 or more are present in the row.</p>
  <p>I would like this to be <strong>dynamic</strong>, so I can specify which instance <code>@</code> I would like the split to occur on.</p>
  <p>So far all I have been able to do is the count the number of <code>@</code> found and if greater than 1, say &quot;test&quot;.</p>
  <p>I could just split using the inbuilt split by delmiter and select the first instance but Its actually interesting to know how to do this for say the 4th instance. This doesnt appear to be an option. You can use Extract data after delimiter and specify there, but wondering if there is a more straigh forward solution.</p>
  <pre><code>let
      Source = Excel.CurrentWorkbook(){[Name=&quot;Table1&quot;]}[Content],
      #&quot;Changed Type&quot; = Table.TransformColumnTypes(Source,{{&quot;Column1&quot;, type text}}),
      #&quot;Added Custom&quot; = Table.AddColumn(#&quot;Changed Type&quot;, &quot;Custom&quot;, each if List.Count(Text.PositionOf([Column1],&quot;@&quot;, Occurrence.All)) &gt; 1 then &quot;test&quot; else null)
  in
      #&quot;Added Custom&quot;
  </code></pre>
  <p>Data:</p>
  <pre><code>Apple Pear @ bananna
  Apple cherry orange @ lime pinapple @ lemon 
  Kiwi @ banana
  Orange @ lime @
  Strawberry @ Blueberry @
  </code></pre>