How to read comma separated .txt file in MATLAB ?

161 views (last 30 days)
How to read comma separated .txt file in matlab ?
The rows is like this :
and so on
I want to store the columns after the "#A-R=" in 2D matrix, (I mean only the number values)

Accepted Answer

Cris LaPierre
Cris LaPierre on 1 Jul 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

More Answers (1)

Abhishek Tiwari
Abhishek Tiwari on 1 Jul 2022
Edited: Abhishek Tiwari on 1 Jul 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 (
  2. Split strings at delimiters - MATLAB split (

Community Treasure Hunt

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

Start Hunting!