find text in text file

3 views (last 30 days)
sander de lange
sander de lange on 25 Oct 2020
Commented: Peter Perkins on 19 Nov 2020
I want to find a specific text line in my text file, how do i code this? In this code I want to fill in time and then get the number of colum two, is there anybody who can help?
09:48:40 0 1
09:48:42 0 1
09:48:44 0 1
09:48:46 0 1
09:48:48 0 1
09:48:50 0 1
09:48:52 0 1
09:48:54 0 1
09:48:56 1788 1
09:48:58 0 1
09:49:00 0 1
09:49:02 0 1
  4 Comments
sander de lange
sander de lange on 25 Oct 2020
Hi guys Thanks for the quick reaction. However I think wasn't that clear. But what I want is a code/function that gives me the linenumber of for example 9:48:56. Can you guys help me with that?
Peter Perkins
Peter Perkins on 19 Nov 2020
+1 to Walter's suggestion. Make a timetable with duration row times, then just use 9:48:56 as a row subscript, perhaps as tt('9:48:56',:) or perhaps as tt.Var1('9:48:56').

Sign in to comment.

Answers (2)

Stephen23
Stephen23 on 25 Oct 2020
>> T = readtable('temp0.txt','Delimiter','\t','ReadVariableNames',false)
T =
Var1 Var2 Var3
__________ ____ ____
'09:48:40' 0 1
'09:48:42' 0 1
'09:48:44' 0 1
'09:48:46' 0 1
'09:48:48' 0 1
'09:48:50' 0 1
'09:48:52' 0 1
'09:48:54' 0 1
'09:48:56' 1788 1
'09:48:58' 0 1
'09:49:00' 0 1
'09:49:02' 0 1
>> X = strcmp(T.Var1,'09:48:56');
>> Y = T.Var2(X)
Y =
1788

Walter Roberson
Walter Roberson on 25 Oct 2020
fileread and regexp() 'split' using pattern '\r?\n' on that to get lines. Now regexp() that cell array of character vectors giving the target time as the pattern and 'once' option. cellfun @isempty and ~ the resulting vector and find() to get the line number.
This for the new requirement that the desired output is the line number. The code for the original task of extracting the second column would have been notably simpler.

Categories

Find more on Data Import and Export 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!