How can I read a text file as fixed width columns?
5 views (last 30 days)
Show older comments
Hello,
I have a traffic cards with information about traffic every 15 minutes, over one year I will have 2500 rows in every card. each row must be divided into 25 columns with a fixed width as shown in the next line.
Column widths: 1 2 6 1 1 2 2 2 2 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 how can I do this in matlab please?
1 Comment
Accepted Answer
dpb
on 31 Aug 2017
Edited: dpb
on 31 Aug 2017
cw=[1 2 6 1 1 2 2 2 2 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5];
fmt=sprintf('%%%dd',cw);
% file open preamble code here for opening file, return valid fid
data=cell2mat(textscan(fid,fmt,'collectoutput',1));
Above presumes all are integer fields, if data does include floating point values fix up format fields to match.
PS: Do not use user ids for tags in future...
More Answers (0)
See Also
Categories
Find more on Migrate GUIDE Apps 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!