title: gawk FIELDWIDTHS convert to CSV, but convert cents to dollars for some fields
body: <p>I am converting a transaction detail file received from the bank from fixed width into a CSV file.</p>
  <pre><code> gawk '$1=$1' FIELDWIDTHS='1 8 12 23 6 6 6 7 13 9 3 10 1 2 3 1 3 1 1 2 6 3 12 3 3 1 2 9 19 140  ' OFS=, $f  &gt;&gt; $csvfilename
  </code></pre>
  <p>Some of the fields are currency fields and listed in cents.
  For example, the second last field will have a value &quot;1234567&quot;.
  However, the value I want output is  &quot;12345.67&quot;.</p>
  <p>I am looking for how I can do that conversion. Something like</p>
  <pre><code>FIELDWIDTHS='1 8 12 23 6 6 6 7.2 13 '
  </code></pre>
  <p>As an example. the following input is received</p>
  <blockquote>
  <p>1000000000000027302080000000541282******876421111821111821111800648300000000021687000000000PU
  831712     DR90 020N000000000323132106663755<br />
  0000000000000000000000000000000000000000000000000000000000000000000
  00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000</p>
  </blockquote>
  <p>The resulting CSV file is</p>
  <blockquote>
  <p>1,00000000,000002730208,0000000448387******6098,211115,211116,211116,0120456,0000000051580,000000000,PU
  ,754045    , ,DR,90 ,0,20N,0,0,00,000003,211,31912995587 ,   ,
  0,0,00,000000000,0000000000000000000,0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000</p>
  </blockquote>
  <p>The 8th field has a value &quot;0120456&quot;.
  I would like the value in the resulting comma delimited file to read &quot;01204.56&quot;</p>