title: Split column based on ascii value
body: <p>I have a <strong>text</strong> field in a table that contains a large string, each part of the string that i want to separate is split by a little square. </p>
  
  <p>When searching I found out this could be an ascii value, so i run this</p>
  
  <p><code>ascii(substring(image_data, 18,1))</code></p>
  
  <p>which returned <strong>27</strong></p>
  
  <p>How would go about splitting this field into separate fields based on this ascii value? </p>
  
  <p>Thanks in advance,
  Chris</p>
  
  <p>EDIT: Example of what the data currently looks like. Having the TEXT before the = as the Header would be great if it is possible.</p>
  
  <p>ABS_ID=1234567 PERSON_ID=1234567 PARTY_ID= ABS_D=123 ABS_T= ABS_TYPE_ID=12345 ABS_ED=123456</p>
  
  <p>The ascii values are where the spaces are in the above example of the field data</p>
  
  <p><a href="https://i.stack.imgur.com/0T2Mp.png" rel="nofollow noreferrer">Example image of the current data</a></p>
  
  <p><a href="https://i.stack.imgur.com/cfeID.png" rel="nofollow noreferrer">Example of the output im trying to get</a></p>
  
  <p><strong>UPDATE</strong>
  The code provided below works great for the example i initially given. When implementing it i discovered the Audit string is different depending on the ENTITY_NM </p>
  
  <p><a href="https://i.stack.imgur.com/jjqDX.png" rel="nofollow noreferrer">Example HERE</a></p>