readtable bug with tab delimiter and commas within a field.
13 次查看(过去 30 天)
显示 更早的评论
Consider a tab-delimited text file, in which a given field may contain a string with commas, e.g.
......
A<tab>B<tab>C,D,E<tab>F
.......
Matlab's "readtable" function with delimiter=\t will parse the third field ("C,D,E") into multiple lines, rather than treating it as one field.
That is, the command:
readtable( filename, 'FileType', 'text', 'Delimiter', '\t', 'ReadRowNames', 0 , 'ReadVariableNames', 0)
will NOT return a table with the 3rd column/Variable having value "C,D,E" but rather split that field into multiple lines/entries (very strange).
3 个评论
Chris Turnes
2015-9-18
Can you post a small portion of your file that can reproduce the issue? I wasn't able to reproduce with a file that was:
A<tab>B<tab>C,D,E<newline>
F<tab>G<tab>H,I,J
You might also want to try specifying the 'Format' parameter and see if that helps.
Peter Perkins
2015-9-21
cmo, I can't reproduce this in any version of MATLAB since R2013b. You haven't said what version or platform you're running on.
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 String Parsing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!