replace a numerical with a string within a csv file.

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.

[madhan ravi]

Upload your csv file.

[karan goyal]

not able to upload

Answer 1

[Gani]

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

[karan goyal]

thanks it worked