how to load an ASCII file

158 views (last 30 days)
I am trying to load an ASCII file that I downloaded from CST. But the usual load tricks that I do don't seem to work and I cannot seem to find the correct method to load the file. The ASCII text file has multiple columns and a the headers are seperated from the rest of the column with one row of --------- signs. This makes it harder to put the columns into variables. Is there any advice to fix this issue?
Thank you,
Nandakumar
  3 Comments
KSSV
KSSV on 25 Jul 2020
Read about textscan. This might be useful.
Nandakumar Unnikrishnan
Nandakumar Unnikrishnan on 25 Jul 2020
I am attaching Trial 1.zip (since the txt file was too big). I tried textscan too, but that did not seem to work correctly. I could have used it wrong, but since I've not used it before I don't know for sure.

Sign in to comment.

Accepted Answer

jonas
jonas on 25 Jul 2020
Edited: jonas on 26 Jul 2020
Based on the sample given in the comments
A = readmatrix('Trial 1.txt')
or better yet,
opts = detectImportOptions('Trial 1.txt','VariableNamesLine',1);
T = readtable('Trial 1.txt',opts);
for older versions you can use textscan
fid = fopen('Trial 1.txt')
out = textscan(fid,repmat('%f',1,10),'headerlines',2,'collectoutput',1)
fclose(fid)
  5 Comments
jonas
jonas on 26 Jul 2020
I've updated the answer to include textscan()
Nandakumar Unnikrishnan
Nandakumar Unnikrishnan on 26 Jul 2020
Thank you. This seems to work now

Sign in to comment.

More Answers (0)

Categories

Find more on Startup and Shutdown in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!