filling blank cell area with spaces

[Anon]

i would like to know if it possible to take a record from a table and fill the blank area of cell with spaces.

our catalog system can import the order list but the list is read as Cobal ( i think) and each cell is a certain length long. it reads the record as one line and the different cells start and end at different character length numbers. so...

if a mysql table had three cell and each had data in them that was three characters long, we could normally export it as XXX,XXX,XXX

BUT,
the system reads the cells as one long row. so if all the cells are supposed to be 5 characters long i would need to export the file as XXXSPACESPACEXXXSPACESPACEXXXSPACESPACE

does this make sense?

is there any way to do this?

thanks

[flipis]

Ok, try this one:

$ArrayCells = Array('abc','cde','def'); //This would be the array containing your data from the db. Example only :-)

$NumCells = count($ArrayCells);
for($i=0;$i<$NumCells;$i++){
$NewArray[$i] = $ArrayCells[$i]." ";
echo $NewArray[$i];
}

As you can see, the data is separated by two spaces at the end. Like this text.

Hope this helps

fLIPIS