read / output a CSV file

[amit290]

I've got a CSV file I need to output. The content format is like this:

adcr1;6
adcr2;11
adcr3;1
adopen;36
brama9;1
bsb2b;5
bsb2c;1
memg9;5

Is it possible to split the content where the semi-colon is so I can output it like this:

ADCR1 = 6
ADCR2 = 11
ADCR3 = 1
etc.

Also how do I get them to appear on seperate lines? They are on seperate lines in the CSV file.

Thnx

[Chuckie]

Also how do I get them to appear on seperate lines? They are on seperate lines in the CSV file.

Do you have to use php?

it shouldn't be hard.. I don't know the syntax, but basically break each componet up into a variable (or you can use an array) then just output them from the variables and concatnate them with an equals sign. The hardest part will proably be opening and reading the file.

[BenANFA]

Opening and reading a file isn't hard try

$file_line = file( <FileName> ); 

This assigns $file_line as an array with each array entry being a string contining 1 line of the file

then you can do something like

foreach( $file_line as $line )
{
  $line = trim($line);

  /* Skip blank lines */
  if ( 0 == strlen( $line ) )
    continue;

  $line_data = explode ( ";", $line );

  echo( $line_data[0] . " = " $line_data[1] . "\n" );
} 

[anode]

Or str_replace(';', '=', $line).