Manipulating Data Within An Array

[scriderpsd]

I have an array called $data which I got from parsing a file. When I do print_r ($data) I get...

Array 
( 
    [0] => ('010907', '010907', 'Illness                 ') 
    [1] => ('010807', '010907', 'Professional Leave      ') 
    [2] => ('010807', '010907', 'Professional Leave      ') 
    [3] => ('010807', '010807', 'Sick Leave              ') 
    [4] => ('010807', '010807', 'Illness                 ') 
    [5] => ('010807', '010807', 'Sick Leave              ') 
    [6] => ('011007', '011007', 'Professional Leave      ') 
    [7] => ('011107', '011107', 'Professional Leave      ') 

..... 

)

Now, I need to be able to go through that array and change 'Illness' to '1' and 'Professional Leave' to '2' and 'Sick Leave' to '3', etc.

So my question is, now that I have this broken down into an array, how do I go in and manipulate the values in the array???

Thanks in advance.

[laserlight]

It is just a two dimensional array, so you would use $data[$i][$j] to access the jth element of the ith array in $data. I suspect you are looking for something like this:

$items = array();
$item_count = 1;
foreach ($data as $key => $value) {
    $item = trim($value[2]);
    if (!in_array($item, $items)) {
        $items[$item] = $item_count;
        ++$item_count;
    }
    $data[$key][2] = $items[$item];
}

In this case I have chosen to use a foreach loop, thus $value is the current subarray of $data.

[scriderpsd]

Thanks for your help Laserlight. I'm not exactly sure if this is what I'm looking for or not. Do I need to populate the $items array with the something? Like this...

$items = array(

array('Illness', 1),
array('Professional Leave', 2),
array('Sick Leave', 3)

);

[laserlight]

No, I am taking it right from your example.

[Weedpacket]

Hmm...

$changes = array(
	'Illness'=>0,
	'Professional Leave'=>1,
	'Sick Leave'=>2
);


foreach($data as &$record)
{
	$designation = rtrim($record[2]);
	if(isset($changes[$designation]))
		$record[2]=$changes[$designation];
}
unset($record);

And if the designation is guaranteed to be in the $changes array then the if() test can be skipped.

[thread_PHP]

Thanks