how to remove header row
70 views (last 30 days)
Show older comments
Hi
I have a file and need to extract lines with specific names, namely rows that their forth colomns are str*dep01
So I used data inport tool to read it into a table
writetable(FAULTSTATIONS,'FAULTSTATIONS.txt','Delimiter',' ','WriteRowNames',true)
type 'FAULTSTATIONS.txt'
then I got
VarName1 VarName2 VarName3 VarName4 VarName5
-150000 -100000 0 "str01dep01" 1
-132765.8649 -100000 -3038.843 "str01dep02" 1
-103221.6342 -100000 -8248.288 "str01dep03" 1
-73677.42052 -100000 -13457.73 "str01dep04" 1
-14588.95908 -100000 -23876.62 "str01dep05" 1
I need to remove the header first (VarName1........VarName5) and use something like
filename = 'FAULTSTATION.txt';
? = importdata(filename);
I am sorry I have no idea what to do,would you please tell me what to do
0 Comments
Answers (1)
madhan ravi
on 9 Jan 2019
Edited: madhan ravi
on 9 Jan 2019
t=readtable('FAULTSTATIONS.txt'); % tables by default have variable names so covert to cell
table2cell(t)
See Also
Categories
Find more on String Parsing in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!