title: Parsing text files using pentaho
body: <p>I have a large number of text files that I need to load into a database. Instead of being in the more usual csv format they are structured like this:</p>
  
  <pre><code>TY  - JOUR
  T1  - On the Structure and Life-History of Entyloma ranunculi (Bonorden)
  JF  - Philosophical Transactions of the Royal Society of London. B (1887-1895)
  VL  - 178
  SP  - 173
  EP  - 185
  PY  - 1887/01/01/
  UR  - http://dx.doi.org/10.1098/rstb.1887.0008
  M3  - doi:10.1098/rstb.1887.0008
  AU  - Ward, H.
  ER  -
  </code></pre>
  
  <p>Where each line is a different field, field name denoted by the leading characters .</p>
  
  <p>What I would like to do is load each of the lines into a corresponding field in the record. I would like to do this via pentaho, anyone got any idea how to accomplish this. The text input step is set up for csv input.</p>