problem with csv to .m conversion

1 view (last 30 days)
Arif Ahmed
Arif Ahmed on 5 Jul 2020
Edited: Rik on 6 Jul 2020
Hello,
I am having problem reading in this file to matlab.
Data = fileread('100Cr6.csv');
Data = strrep(Data, ',', '.');
FID = fopen('kf100CR6.m', 'w');
fwrite(FID, Data, 'char');
fclose(FID);
i use the following code but it does not generate the data what i want?
i want every data in double notation (like 1231.2354) format. so that i can use these as columns or rows of matrix.
Does anyone have a solution to this?
Many thanks.

Answers (1)

jonas
jonas on 5 Jul 2020
try readmatrix() or readtable() instead
Data = readmatrix('100Cr6.csv','NumHeaderlines',1,'DecimalSeparator',',');
  4 Comments
Arif Ahmed
Arif Ahmed on 5 Jul 2020
Edited: Rik on 6 Jul 2020
Data = readtable('100Cr6.csv','NumHeaderlines',0,'DecimalSeparator',',');
% FID = fopen('kf100CR6.m', 'w');
fid = fopen('kf100CR6.m', 'wt'); % Open m-file for writing as a text file.
if fid ~= -1
[rows, columns] = size(Data)
fprintf(fid, '', Data)
fclose(fid)
end
how can i write the data from .csv to .m file?
jonas
jonas on 6 Jul 2020
What is the problem?

Sign in to comment.

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!