How to rename TABLE column by the combination of Character and number?

Dear all, pertaining of the above subject. I have the following code

c=1
for threshold = 0.5:0.01:0.6
for i =1:2
Table (c) = SomeFunction
end
% See line A
Table.Properties.VariableNames{c} = NewName
c=c+1
end

To have a new column name after each iteration of the threshold loop, I plan to rename the column name, for example, the column 1 and 2 is threshold_0_5 and threshold_0_51. The reason why threshold_0_5 and threshold_0_5 1 because MATLAB prohibit naming the column as threshold_0.5 & threshold_0.5.

By looking at the other thread,

possible conversion was

Data = strrep(threshold , '.', '_');
NewName = strcat ('threshold ',Data)

OR

NewName = strcat('Th',num2str(threshold)),

However, I got an error. May I know where did I do wrong?

Thanks in advance

Answer 1

[Star Strider]

I am not certain what result you want. All table variable names have to be valid MATLAB variable names, so decimal points are not permitted.

Try this:

threshold = 0.5:0.01:0.6;
NamesVct = sprintf('Th_%2.0f\n',threshold*100);
NewName = regexp(NamesVct, '\n', 'split');
NewName = NewName(1:end-1);

The last line is necessary because the regexp call produces an empty cell at the end.

[balandong]

Hi SS, Thanks for replying and provide some insight. I had delete my previous reply. Seem you modified some of your code. Yup, think this one work-around we can do by multiplying the threshold with 100. However do you have any suggestion if we want to make it something have something like TH_0_5. Any how, I will accept your suggestion, as this the best alternative I have now. Thank YOU so much

[Star Strider]

It is easier to do that in the sprintf call:

threshold = 0.5:0.01:0.6;
NamesVct = sprintf('Th_0_%2.0f\n',threshold*100);
NewName = regexp(NamesVct, '\n', 'split');
NewName = NewName(1:end-1);

NewName =

    1×11 cell array

    Columns 1 through 6

      'Th_0_50'    'Th_0_51'    'Th_0_52'    'Th_0_53'    'Th_0_54'    'Th_0_55'

    Columns 7 through 11

      'Th_0_56'    'Th_0_57'    'Th_0_58'    'Th_0_59'    'Th_0_60'

[balandong]

It works like a charm. Thanks SS

[Star Strider]

As always, my pleasure.