Why does readmatrix return empty matrix if text file contains quotes?
조회 수: 5 (최근 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)
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!