how to remove header row

159 ビュー (過去 30 日間)
Samaneh Arzpeima
Samaneh Arzpeima 2019 年 1 月 9 日
コメント済み: Samaneh Arzpeima 2019 年 1 月 9 日
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

回答 (1 件)

madhan ravi
madhan ravi 2019 年 1 月 9 日
編集済み: madhan ravi 2019 年 1 月 9 日
t=readtable('FAULTSTATIONS.txt'); % tables by default have variable names so covert to cell
table2cell(t)
  1 件のコメント
Samaneh Arzpeima
Samaneh Arzpeima 2019 年 1 月 9 日
thank you,I've got a cell without the header row. not sure how to extract what i need.
I wanted to import the original file to text file, delete the first line and save the remaining lines to a new text file. Then extract those rows which their 4th colomns match with
str * dep01

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeString Parsing についてさらに検索

製品

Community Treasure Hunt

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

Start Hunting!

Translated by