Effacer les filtres
Effacer les filtres

How can I remove characters in cvs file?

16 vues (au cours des 30 derniers jours)
Sara Reyburn Valés
Sara Reyburn Valés le 18 Mar 2021
Modifié(e) : Seth Furman le 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 commentaires
Sara Reyburn Valés
Sara Reyburn Valés le 18 Mar 2021
This is the one I have been using as a test
Sara Reyburn Valés
Sara Reyburn Valés le 18 Mar 2021
I updated my version of matlab and now it works
Thank you so much!!

Connectez-vous pour commenter.

Réponse acceptée

Stephen23
Stephen23 le 18 Mar 2021
Modifié(e) : Stephen23 le 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
  1 commentaire
Sara Reyburn Valés
Sara Reyburn Valés le 18 Mar 2021
Okay, Thank you so much!!

Connectez-vous pour commenter.

Plus de réponses (1)

Seth Furman
Seth Furman le 18 Mar 2021
Modifié(e) : Seth Furman le 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

Catégories

En savoir plus sur Logical dans Help Center et File Exchange

Produits


Version

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by