<turbo-stream action="update" target="wiki_99_subpage_168_info"><template>
<h1>MIDDLE(data, substring);</h1>
<p>Using this function, your program will return the middle string according to what you specify.</p>
<p>&nbsp;</p>
<p><strong>Example:</strong></p>
<blockquote>
<p>The field value is&nbsp; 'One Two Three'.</p>
<p><br>MIDDLE(data, ' ');<br>Returns 'Two'.</p>
<p><br>MIDDLE(data, 'One');<br>Returns '0' (null).</p>
<p><br>MIDDLE(data, 'T');<br>Returns&nbsp; 'wo ' (with a blank at the end).</p>
</blockquote>
</template></turbo-stream>
<turbo-stream action="prepend" target="flash"><template></template></turbo-stream>
