How To Get Number Of Columns in Non-Rectangular Array of Data for textscan Function
1 view (last 30 days)
Show older comments
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 Comments
Answers (1)
Star Strider
on 19 Apr 2017
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 Comments
Star Strider
on 19 Apr 2017
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.
See Also
Categories
Find more on Text Files in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!