MATLAB Answers

How can I remove characters in cvs file?

1 view (last 30 days)
Sara Reyburn Valés
Sara Reyburn Valés on 18 Mar 2021
Edited: Seth Furman on 18 Mar 2021
Hi!
I have several csv files with the information strutured as
"1";"2";"3";
and I need to access the informations as matrixes.
I have tried readmatrix, and readmtx, but the " " are really bothering me. When I tried readtable, it gets the information but doesn't save it as a number, so potentially I could transform the table to a matrix, but I haven't been able to.
I tried to use:
T2= replace(T1,' " ',' ')
Any help would be appreciated! Thanks!!
  4 Comments
Sara Reyburn Valés
Sara Reyburn Valés on 18 Mar 2021
I updated my version of matlab and now it works
Thank you so much!!

Sign in to comment.

Accepted Answer

Stephen
Stephen on 18 Mar 2021
Edited: Stephen on 18 Mar 2021
Using string manipulation:
str = fileread('prueba1.csv');
str = strrep(strrep(str,'"',''),';',' ');
mat = sscanf(str,'%f',[3,Inf]).'
mat = 5×3
234 42 243 456 34 23 678 75 765 456 355 65 647 78 75
Or using TEXTSCAN:
fmt = '%f%f%f';
opt = {'Delimiter','";', 'MultipleDelimsAsOne',true, 'CollectOutput',true};
fid = fopen('prueba1.csv','rt');
tmp = textscan(fid,fmt,opt{:});
fclose(fid);
mat = tmp{1}
mat = 5×3
234 42 243 456 34 23 678 75 765 456 355 65 647 78 75

More Answers (1)

Seth Furman
Seth Furman on 18 Mar 2021
Edited: Seth Furman on 18 Mar 2021
If you use readtable, you can convert the table to a matrix by using the table2array function.
For example,
>> readtable('prueba1.csv')
ans =
5×3 table
Var1 Var2 Var3
____ ____ ____
234 42 243
456 34 23
678 75 765
456 355 65
647 78 75
>> table2array(ans)
ans =
234 42 243
456 34 23
678 75 765
456 355 65
647 78 75

Products


Release

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by