Index character in table

In a dataset, I would like to get rid of the letter within the seatnumber on an aircraft: '026C' to 026. For this I am trying to index the first three characters of the string, which I can't get to work.

This is one of the things I tried:

A = cell(1,2);
A{1,1} = '024C';
A{1,2} = '005B';

A(1,1) = A(1,1,1:3)

Can somebody tells me how this indexing works?

Answer 1

[KL]

another way is to use regexprep,

 A_new = regexprep(A,'[A-Z]','')
 A_new =
  1×2 cell array

    '024'    '005'

[Jeroen Delfos]

Thank you. I understand this removes any letters [A-Z], instead of the character on the fourth place of the string? I think that is actually what I was searching for.

[KL]

Please note that it's case-sensitive. Since you mentioned seat number, I took the liberty to make that assumption.

Answer 2

[Andrei Bobrov]

out = cellfun(@(x)x(1:3),A,'un',0);