MATLAB Answers

readtable bug with tab delimiter and commas within a field.

22 views (last 30 days)
cmo
cmo on 17 Sep 2015
Commented: Peter Perkins on 21 Sep 2015
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 Comments
Peter Perkins
Peter Perkins on 21 Sep 2015
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.

Sign in to comment.

Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!