Why does readmatrix return empty matrix if text file contains quotes?
19 次查看(过去 30 天)
显示 更早的评论
Function readmatrix fails to read data from text file when it contains quotes. Why? How to make readmatrix working?
Extended example:
let first text.txt be:
header1
header2
1
2
3
footer
then
readmatrix('text.txt', 'Range', [3 1 5 1])
gives usual vector [1;2;3].
But whe text.txt is like this:
"
header2
1
2
3
"
readmatrix returns empty vector while dlmread works fine.
How to force readmatrix ignore quotes?
3 个评论
Stephen23
2024-5-15
"Function readmatrix fails to read data from text file when it contains quotes. Why?"
Because double quotes indicate that everything until the next double quote are considered to be one text string. So your sample file consists of exactly one field with some text in it. This is a basic feature of delimited text files (e.g. CSV).
回答(1 个)
Cris LaPierre
2024-5-15
readmatrix is trying to guess what the file format is. However it is doing that, it appears to not handle this specific configuation as you might expect. My suspicion is that it is treating everything between the 2 quotes as strings, and readmatrix ignores strings.
You might want to consider reporting this here:
1 个评论
Cris LaPierre
2024-5-17
Following up, I do not know of a way around this with readmatrix. However, this code seems to be able to import the file with quotes correctly using readtable.
T = readtable('test_quotes.txt','Format','%f','numHeaderLines',2,'readVariableNames',false,'Whitespace','"');
T2 = table2array(T)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!