How to read comma separated .txt file in MATLAB ?

153 visualizzazioni (ultimi 30 giorni)
How to read comma separated .txt file in matlab ?
The rows is like this :
#A-R=-6.00,20.00,304.00
#A-R=-6.00,22.00,311.00
#A-R=-3.00,22.00,315.00
.
.
.
and so on
I want to store the columns after the "#A-R=" in 2D matrix, (I mean only the number values)

Risposta accettata

Cris LaPierre
Cris LaPierre il 1 Lug 2022
I would use the settings available in readmatrix to make the '=' a delimiter. That will treat the '#A-R' as another column of data. I would then use the 'Range' input to skip the first column.
data = readmatrix("sampleData.txt",'Delimiter',{',','='},'Range','B1')
data = 3×3
-6 20 304 -6 22 311 -3 22 315

Più risposte (1)

Abhishek Tiwari
Abhishek Tiwari il 1 Lug 2022
Modificato: Abhishek Tiwari il 1 Lug 2022
Hi @M
Try strsplit() or split() on rows and string array '#A-R' as delimiter. It divides each element of input at the specified delimiters. If you wish to separate number values, use strsplit() or split() with '#A-R=' and ',' as delimiters. Here are several examples:
temp = "#A-R=-6.00,20.00,304.00";
columns = strsplit(temp, "#A-R=")
columns = 1×2 string array
"" "-6.00,20.00,304.00"
sepColumns = strsplit(temp, ["#A-R=", ","])
sepColumns = 1×4 string array
"" "-6.00" "20.00" "304.00"
Before you begin, look into them.
  1. Split string or character vector at specified delimiter - MATLAB strsplit (mathworks.com)
  2. Split strings at delimiters - MATLAB split (mathworks.com)

Categorie

Scopri di più su Characters and Strings in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by