Alias blanks in the cell array as a string.

17 次查看(过去 30 天)
I am using the ‘importdata’ function to read a text file. It reads the numeric data as a matrix and text data as a cell array; now the first element of cell array is all the headers, I use a ‘strsplit’ function to separate each individual variable name in header. The issue is that there are some blank columns in the text file, so the numeric matrix reads it as a ‘NaN’ but the resulting variables (which I used ‘strsplit’ for) eliminates blanks. Now the result is that size(textdata,2) +size(data,2) is not equal to size(variable,2). I want to read blanks in the header as a variable, alias it as ‘empty’
  5 个评论
Stephen23
Stephen23 2025-1-31
I second dpb's comment: avoid IMPORTDATA, use READTABLE or TEXTSCAN or the like.
Viraj Sabane
Viraj Sabane 2025-2-3
Thank you all. I will experiment with 'readtable' and 'textscan' some more. Really appreciate this community for encourging the correct way of programming.

请先登录,再进行评论。

采纳的回答

Adam Danz
Adam Danz 2025-1-31
As the OP found, the solution is to include multiple delimiters
strsplit(t,'\t', 'CollapseDelimiters',false)
And as others have recommended, using readtable offers better control of how data are read than importdata.

更多回答(1 个)

Viraj Sabane
Viraj Sabane 2025-2-16
Hello All, taking advice of everyone who commented; I was able to robustly solve the issue of dowloading data from a text file and also retain the variable name. This particular text file had variable names in line 1 and line line 1 also had blanks. Following code has worked reliably for me.
And if your text file happen to have many lines before the line with headers, following has worked well for me.

类别

Help CenterFile Exchange 中查找有关 Data Import and Export 的更多信息

产品


版本

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by