title: Databricks - String manipulation via sql command
body: <p>I have a table column that I need to get from databricks whatever appears between the 15th and 16th appearance of the character # as follows the following example:</p>
  
  <p>Column
  1234##E#A#1234#01/01/4500#X#*ABCDE#7#1##N#N#N#0#Z.POIUS.LKJS_20200103#0#</p>
  
  <p>Results
  Z.POIUS.LKJS_20200103</p>
  
  <p>how can I do this?</p>