How to replace a string in a table

I have a table test that says
month
--
'January'
'JANUARY'
I want to replace 'JANUARY' by 'January':
month
--
'January'
'January'
I tried strcmp but I got an error message "conversion to cell from char is not possible." Please advise.

 采纳的回答

Mara
Mara 2020-6-18
编辑:Mara 2020-6-18
test = table();
test.month = 'JANUARY';
test.month = lower(test.month); %writes it in lower case letters
or you can as well just replace it by your desired input
test.month = 'january';
P.S. You do not have a string but a character (char)

5 个评论

IQ=IQ+1;
Is it possible to have 'January' that is the first letter capital but the followins are lower?
you can index into your character like a normal array: test.month(2:end) = lower(test.month(2:end)), so that the first character is not changed
It only works for the first row.
Mara
Mara 2020-6-18
编辑:Mara 2020-6-18
then you have to specify that you want every row:
test.month(:,2:end) = lower(test.month(:,2:end));
IQ=IQ+1; % Thank you.

请先登录,再进行评论。

更多回答(1 个)

I am providing a solution, i suspect it's not the ideal solution but it should work.
test = table();
test.month{1} = 'JANUARY';
test.month{2} = 'January';
for index = 1:length(test.month)
if(test.month{index}=='JANUARY')
test.month{index} = 'January';
end
end

1 个评论

It depends on whether you have a cell array containing characters or characters solely. From the previous error message that occured ("conversion to cell from char is not possible.") , I concluded, that it is stored as characters only. In which case it does not let you index with curly braces
this worked for me:
test = table();
test.month = {'JANUARY'; 'FEBRUARY'; 'MARCH'}; %cell
test.month = char(test.month); %conversion to character array
test.month(:,2:8) = lower(test.month(:,2:8)); %indexing with normal braces

请先登录,再进行评论。

类别

帮助中心File Exchange 中查找有关 Introduction to Installation and Licensing 的更多信息

产品

版本

R2020a

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by