I Want to change the last column of a cell 25*5 from characters ie {'Fd,Fc,Fb,Fr'} to numbers, [1,2,3,4]. the code must find for Ex. Fd and replace it with 1 and so on.Thanks

I have a cell 1*11 inside which there is 11 cells of dimensions 25*5.I Want to change the last column of a cell 25*5 from characters ie {'Fd,Fc,Fb,Fr'} to numbers, [1,2,3,4]. the code must find for -Ex. Fd and replace it with 1 and so on...

2.27000000000000 240.200000000000 49.6100000000000 0 'Fd'

2.45000000000000 214.610000000000 37.8800000000000 0 'Fd'

4.52000000000000 143.200000000000 6.41000000000000 0 'Fc'

4.60000000000000 51.9000000000000 51.5500000000000 0 'Fc'

4.69000000000000 48.3800000000000 54.9000000000000 0 'Fd'

4.74000000000000 55.0400000000000 24.9100000000000 0 'Fd'

Can someone please help.

Thank you

Answer 1

[Voss]

You can do this for each of the 11 cells:

C = { ...
    2.27000000000000	240.200000000000	49.6100000000000	0	'Fd'
    2.45000000000000	214.610000000000	37.8800000000000	0	'Fd'
    4.52000000000000	143.200000000000	6.41000000000000	0	'Fc'
    4.60000000000000	51.9000000000000	51.5500000000000	0	'Fc'
    4.69000000000000	48.3800000000000	54.9000000000000	0	'Fd'
    4.74000000000000	55.0400000000000	24.9100000000000	0	'Fd'};

lookup = {'Fd' 'Fc' 'Fb' 'Fr'};
[ism,idx] = ismember(C(:,end),lookup);
C(ism,end) = num2cell(idx(ism));
disp(C)

    {[2.2700]}    {[240.2000]}    {[49.6100]}    {[0]}    {[1]}
    {[2.4500]}    {[214.6100]}    {[37.8800]}    {[0]}    {[1]}
    {[4.5200]}    {[143.2000]}    {[ 6.4100]}    {[0]}    {[2]}
    {[4.6000]}    {[ 51.9000]}    {[51.5500]}    {[0]}    {[2]}
    {[4.6900]}    {[ 48.3800]}    {[54.9000]}    {[0]}    {[1]}
    {[4.7400]}    {[ 55.0400]}    {[24.9100]}    {[0]}    {[1]}

M = cell2mat(C) % now (maybe) C can be made into a numeric matrix

M = 6×5

2.2700 240.2000 49.6100 0 1.0000 2.4500 214.6100 37.8800 0 1.0000 4.5200 143.2000 6.4100 0 2.0000 4.6000 51.9000 51.5500 0 2.0000 4.6900 48.3800 54.9000 0 1.0000 4.7400 55.0400 24.9100 0 1.0000

[Zahir Elharith Mohammedelamein Ahmed]

thank you for your support, but I am trying to replace the Cha. with numbers, ex. instead of (Fd) put 1 and instead of Fc put 2, instead of Fr put 3 .... and so on..

I have four characters: { 'Fd' 'Fc' 'Fo' 'Fr' };

I want to change them with four numbers : [1,2,3,4]

each number for a character.

Thank you

[Voss]

That's what my answer does, no?

[Zahir Elharith Mohammedelamein Ahmed]

No it does not it gives me only 1,2 and 0 idx

[Voss]

If you get some values of idx equal to 0 it means some elements of C(:,end) are not in the set of characters lookup, so make sure you are using the right set of characters, because you mentioned these in the question:

{'Fd' 'Fc' 'Fb' 'Fr'}

Then you said it's these:

{'Fd' 'Fc' 'Fo' 'Fr'}

(note the 'Fo' instead of 'Fb')

And make sure they're in the right order, because in your last comment you said "instead of Fr put 3", but 'Fr' is 4th.