title: Pentaho convert string to integer with decimal point
body: <p>I am importing text values into a transformation using a Fixed Width input step.  Everything is coming in as a string.  I want to convert some of the string values to integers with a decimal point at a specified spot.  Here are some examples of the before (left hand side) and expected results (right hand side):</p>
  
  <pre><code>00289 --&gt; 0028.9
  01109 --&gt; 0110.9
  003201 --&gt; 0032.01
  </code></pre>
  
  <p>I've tried numerous combinations of the Format mask in a Select Values step  (meta data tab) but I can't get the values I'm looking for.  </p>
  
  <p>Can you anyone tell me what combination I can try for* Type/Length/Precision/Format/Encoding/Decimal/Group* attributes for these fields to get the desired output?</p>