# How to read comma separated .txt file in MATLAB ?

177 views (last 30 days)
M on 1 Jul 2022
Answered: Cris LaPierre on 1 Jul 2022
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)

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 = 3×3
-6 20 304 -6 22 311 -3 22 315

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.