title: Parse a PIPE delimited field into seperate fields (MS ACCESS 2007-2013)
body: <p>I have a database in MC Access 2017-2013 where the fields are stored as a PIPE delimited string. Now I want a way to parse these fields in a SELECT query in separate fields.</p>
  
  <p>Here an example of my database and the PIPE delimited field:
  <a href="https://i.stack.imgur.com/4VqAN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4VqAN.png" alt="Database Example"></a></p>
  
  <p>The field contains 9 Pipes. So I want to separate the field in 10 fields.</p>
  
  <p>Here an example of the Output:
  <a href="https://i.stack.imgur.com/EDyaP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EDyaP.png" alt="Output Example"></a></p>
  
  <p>I would be great, if someone could help me.<br>
  Thanks,
  Peter</p>