Help With Flat File Conversion?

[arkman]

I have a space delimited file that I need to do a little manipulation of an then convert to a comma separated file. I have the conversion working alright, but I'm not sure of the manipulation?

The rows look like this:

9780002005531 2 0 0 1 41.N

And I'd like to have them look like this:

9780002005531,2,0,0,1,41.00,N

The second last field will always have two decimal places appended.

The code I have for conversion is like so:

$lines = file($opt['i']);
foreach ($lines as $line) {
  $line = preg_split("/ /", $line);
  foreach ($line as $field) {
    $field = chop($field);
    if ($field != "") {
        fwrite($fh, "$field,");
      }
    }
  fwrite($fh, "\n");
}

I'm just not sure where, and how, to do the manipulation?

Thanks in advance.

[laserlight]

This might be a possible solution:

$lines = file($opt['i']);
foreach ($lines as $line) {
    $line = explode(' ', rtrim($line)); // Assume field separator is one space.
    $line[count($line)-2] .= '00'; // Append 2 decimal places to 2nd last field.
    $line = implode(',', $line);   // Convert to comma separated fields.
    fwrite($fh, $line . "\n");
}

Of course, it makes some assumptions that may not hold, including the assumption that there are at least two fields.

[arkman]

Almost there. the spacing is not consistent though so that assumption is incorrect. The rows actually look like this:

9780002005531       2     0     0   1        41.N

[laserlight]

In that case, you can substitute explode() with preg_split() and '/ +/' as the pattern.