title: Kusto query language split @ character and take last item
body: <p>If I have a string for example:
  &quot;this.is.a.string.and.I.need.the.last.part&quot;
  I am trying to get the last part of the string after the last &quot;.&quot;, which in this case is &quot;part&quot;
  How to I achieve this?
  One way I tried was to split the string on &quot;.&quot;, I get a array back, but then I don't know how to retrieve the last item in the array.</p>
  <pre><code>| extend ToSplitstring = split(&quot;this.is.a.string.and.I.need.the.last.part&quot;, &quot;.&quot;) 
  </code></pre>
  <p>gives me:</p>
  <pre><code>[&quot;this&quot;, &quot;is&quot;,&quot;a&quot;,&quot;string&quot;,&quot;and&quot;,&quot;I&quot;,&quot;need&quot;,&quot;the&quot;,&quot;last&quot;, &quot;part&quot;]
  </code></pre>
  <p>and a second try I have tried this:</p>
  <pre><code>| extend ToSubstring = substring(myString, lastindexof(myString, &quot;.&quot;)+1)
  </code></pre>
  <p>but Kusto do not have a function of lastindexof.</p>
  <p>Anyone with tips?</p>