How to read/load text file without header?

18 Ansichten (letzte 30 Tage)
Sohel Rana
Sohel Rana am 25 Jul. 2023
Kommentiert: Voss am 26 Jul. 2023
Hello,
I have a text file (attached here) which contains headers. How can I read/load just numeric data from the text file? In the attached file, for example, how can I get all data for column wav1-1 or wav1-2, etc?
Thank you!

Akzeptierte Antwort

Voss
Voss am 25 Jul. 2023
readtable seems to work well on this file.
t = readtable('Test Data.txt');
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
head(t) % check the first 10 rows -> looks ok
Date Time LineNumber SystemStatus Wav1_1 Wav1_2 Wav1_3 Wav1_4 Wav1_5 Wav1_6 Wav1_7 Wav1_8 Wav1_9 Wav1_10 Wav1_11 Wav1_12 Pow1_1 Pow1_2 Pow1_3 Pow1_4 Pow1_5 Pow1_6 Pow1_7 Pow1_8 Pow1_9 Pow1_10 Pow1_11 Pow1_12 ______________ ________ __________ ____________ ______ ______ ______ ______ ______ ______ ______ ______ ______ _______ _______ _______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _______ _______ _______ {'2023/07/25'} 13:30:05 17892 {'0 0 0 0'} 1522.2 1526.2 1530.2 1534.2 1537.1 1542.2 1546.1 1550.2 1554.1 1558.1 1561.4 1566.1 29.1 29.2 29 28.4 35.6 36.9 38.1 42.3 41.4 43.6 38 39.8 {'2023/07/25'} 13:30:06 17893 {'0 0 0 0'} 1522.2 1526.2 1530.2 1534.2 1537.1 1542.2 1546.1 1550.2 1554.1 1558.1 1561.4 1566.1 29.1 29.3 29.1 28.3 35.6 36.9 38 42.3 41.4 43.5 38 39.8 {'2023/07/25'} 13:30:07 17894 {'0 0 0 0'} 1522.2 1526.2 1530.2 1534.2 1537.1 1542.2 1546.1 1550.2 1554.1 1558.1 1561.4 1566.1 29.1 29.2 29.1 28.4 35.6 36.8 38 42.4 41.4 43.5 38 39.7 {'2023/07/25'} 13:30:08 17895 {'0 0 0 0'} 1522.2 1526.2 1530.2 1534.2 1537.1 1542.2 1546.1 1550.2 1554.1 1558.1 1561.4 1566.1 29.1 29.3 29.1 28.4 35.6 36.8 38 42.4 41.4 43.6 38 39.7 {'2023/07/25'} 13:30:09 17896 {'0 0 0 0'} 1522.2 1526.2 1530.2 1534.2 1537.1 1542.2 1546.1 1550.2 1554.1 1558.1 1561.4 1566.1 29.1 29.3 29.1 28.4 35.6 36.8 38.1 42.4 41.4 43.6 38 39.8 {'2023/07/25'} 13:30:10 17897 {'0 0 0 0'} 1522.2 1526.2 1530.2 1534.2 1537.1 1542.2 1546.1 1550.2 1554.1 1558.1 1561.4 1566.1 29.1 29.3 29.1 28.4 35.7 36.9 38.1 42.4 41.4 43.4 38 39.7 {'2023/07/25'} 13:30:11 17898 {'0 0 0 0'} 1522.2 1526.2 1530.2 1534.2 1537.1 1542.2 1546.1 1550.2 1554.1 1558.1 1561.4 1566.1 29.1 29.2 29.1 28.3 35.6 36.9 38.1 42.2 41.4 43.5 37.9 39.7 {'2023/07/25'} 13:30:12 17899 {'0 0 0 0'} 1522.2 1526.2 1530.2 1534.2 1537.1 1542.2 1546.1 1550.2 1554.1 1558.1 1561.4 1566.1 29.1 29.3 29.1 28.4 35.6 36.8 38.1 42.3 41.4 43.6 38.1 39.7
% access Wav1-1 column:
t.Wav1_1
ans = 598×1
1.0e+03 * 1.5222 1.5222 1.5222 1.5222 1.5222 1.5222 1.5222 1.5222 1.5222 1.5222
% access Wav1-2 column:
t.Wav1_2
ans = 598×1
1.0e+03 * 1.5262 1.5262 1.5262 1.5262 1.5262 1.5262 1.5262 1.5262 1.5262 1.5262
  2 Kommentare
Sohel Rana
Sohel Rana am 26 Jul. 2023
This is great! Works well.Thank you for your answer.
Voss
Voss am 26 Jul. 2023
You're welcome!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Environment and Settings finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by