How To Get Number Of Columns in Non-Rectangular Array of Data for textscan Function

2 次查看（过去 30 天）

EvanThomas 2017-4-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/336153-how-to-get-number-of-columns-in-non-rectangular-array-of-data-for-textscan-function

评论： Star Strider 2017-4-19

Hello,

I am currently using the following line of code for extracting data from a csv file, which contains non-rectangular array of data

C = textscan(fileID, repmat('%f',[1 22]), Delimiter, ',', 'EmptyValue', NaN);

What I would love to do is replace that 22 with a variable. Right now I need to check the csv, count the columns (currently, 22) and enter that number manually. Is there a way I could automate that and replace 22 with a variable, eliminating the need to look in the csv file in the future?

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Star Strider 2017-4-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/336153-how-to-get-number-of-columns-in-non-rectangular-array-of-data-for-textscan-function#answer_263644

Since your files don’t appear to have header lines, the xlsread or csvread functions might be more appropriate than textscan to import your files.

4 个评论
显示 2更早的评论隐藏 2更早的评论

EvanThomas 2017-4-19

编辑：EvanThomas 2017-4-19

Thanks StarStrider, I had tried csvread already (my go-to import function on most occasions), but it would not work on this data set. Each column is a different length, so it didn't like it. still, I was hoping for a slick way around that. Not really seeing one, likewise with xlsread. textscan is working perfectly right now, I just know sooner, or later, the number of columns will change, and that hardcoded "22" is going to bite me, while I sit and wonder for a while why my script broke because I had since forgotten about it, hehe

Star Strider 2017-4-19

My pleasure.

I’ve found textscan to be rather robust to (my) stretching it beyond its intended limits. In any event, you can always comment your code (good practice anyway) to check your textscan call if your code starts behaving strangely.

请先登录，再进行评论。

请先登录，再回答此问题。