How to replace the contents of a cell array

I have a cell array of 2 columns as follows

Column1  Column2
AA       BB0p0
AA       BB0p5
AA       BB1p0
AA       BB1p5
...and so on

I would like to replace the contents of the 2nd column as follows

BB0p0 = 0
BB0p5 = 1
BB1p0 = 2
BB1p5 = 3 and so on...

I am a matlab newbie, so my apologies if any part of the question is not clear.

Thanks

[Dubstep Dublin]

I think it all boils down to using strrep on a cell array. Can someone please tell me how to do that?

Answer 1

[Walter Roberson]

[unique_col2, ~, col2_idx] = unique(YourCell(:,2));
col2_idx_cell = num2cell(col2_idx - 1);   %the index is 1 based rather than 0 based
YourCell(:,2) = col2_idx_cell;

And the map back of any one stored value is unique_col2{stored_value+1}

Typically you would skip the -1 and +1 in the above and use references starting from 1, but using references starting from 0 is not wrong, and has its uses.

[Dubstep Dublin]

Not quite getting it.

I managed to separate out the column that I want to modify into a separate 1 column cell array as follows:

BB0p0
BB0p5
BB1p0
BB1p5
and so on...

[Walter Roberson]

YourCell = {'AA',  'BB0p0'
            'AA',  'BB0p5'
            'AA',  'BB1p0'
            'AA',  'BB1p5'
            'AA',  'BB1p0'
            'AA',  'BB0p0' };

[unique_col2, ~, col2_idx] = unique(YourCell(:,2));
col2_idx_cell = num2cell(col2_idx - 1);   %the index is 1 based rather than 0 based
YourCell(:,2) = col2_idx_cell;
YourCell

The output is

 YourCell = 

    'AA'    [0]
    'AA'    [1]
    'AA'    [2]
    'AA'    [3]
    'AA'    [2]
    'AA'    [0]

Notice how in each case the right hand side is consistent about the number assigned to any one string.

[Triveni]

Walter Sir's solution is right you should check ";" or repress "YourCell"

[Dubstep Dublin]

Yes it works! Thanks a lot Walter.

I have a followup question: What do I do if I have to replace the contents of the cell as follows.

BB0p0 = 0 BB0p5 = 0.5 BB1p0 = 1.0 BB1p5 = 1.5 and so on...

[Triveni]

At-least you should accept answers when someone help....accept walter's answer