MATLAB: Replace a numerical with a string within a csv file.

delete rowreplace string

FUTAvgTradePrice
19000 FUTTotalTradeQty FUTBestBidVol FUTBestBid FUTBestAskVol
26707 18000 3000 26645 3000
26678 9000 3000 26660 3000
26657 6000 6000 26610 3000
26660 3000 6000 26620 3000
26650 6000 6000 26635 3000
26650 0 3000 26630 3000
26660 3000 6000 26635 3000
26639 9000 9000 26610 6000
IN the above csv file i want to replace 19000 in SECOND ROW AND FIRST COLUMN WITH THE string FUTAvgTradePrice Which is present in the FIRST ROW AND FIRST COLUMN.HOW TO DO IT??(also the file is very big having 45000+ rows and 40+ columns).
ALSO I WANT TO DELETE THE FIRST ROW AFTER THIS HAS BEEN DONE.

Best Answer

Use xlsread and xlswrite
Example: 
[~,~,raw ]= xlsread('C:\Test.csv');
raw{2,1} ='FUTAvgTradePrice'; % setting value 
raw(1, :) = []; % deleting first row
xlswrite('C:\Test.csv', raw); % saving it again
Related Question