Delete rows in cell arrays

Hi,

Have have got the following cell array:

How can I delete the first row of the cell and add to each element in the first row 'Equity'. The end result should be for the first element: '1 HK Equity'

Thank you in advance for your help.

[KSSV]

Attach your data as a matfile. Image snippet will not help us to help you.

[Stephen23]

BdS:'s "Answer" moved here:

it is a local variable. How to save a local variable (which exists during the running of a function)? To run the function one needs connection to bloomberg.

[Stephen23]

"How to save a local variable (which exists during the running of a function)?"

Set a breakpoint in the function on a line that executes after that variable is defined. Once the code pauses, save the variable in a .mat file. Then continue/stop the code execution.

[BdS]

Thank you. My .mat file is enclosed

Answer 1

[KSSV]

load CellBdS.mat ;
s = rawPortData{1}.INDX_MWEIGHT_HIST ; 
s = s{1} ; 
c1 = s(:,1) ; 
% delete first row 
c1(1) = [] ;
% add Equity
c1 = strcat(c1,' Equity') ;