I have a log file which has several timestamp.
I want to extract the data between two timestamp, i am getting starting timestamp value from a variable which i have extracted from a website.
Can anyone help me on this and guide me how to resolve this?
Hi,
Below is the log file which is starting with TimeStamp,
I know the value of First timestamp and i want to extract the data after first timestamp till starting of second timestamp.
[2020-06-08T07:53:37.508+0200] [Payara 4.1] [INFO] [] [tid: _ThreadID=595 _ThreadName=orb-wmq.jmsra-thread-pool (pool #2): worker-9] [timeMillis: 1591595617508] [levelValue: 800] [[
** [IRAM] FAV web service ‘newTURevision’ for change context ‘11349’ was successful and returned the new FAVScopeRevisionId: ‘895469096’]]**
The point is i don’t know the end date
I am extracting the data from a website and filtering the starting timestamp and storing in a variable from it.
Now i want to extract the data after my filtered timestamp and before next timestamp.
@pradyumn.agrawal I have managed to get the data in by using two regex expresssions. But the end data after the Second TimeStamp will not be extracted. Do you want it to be extracted or not since the condition was extracting data between two TimeStamps
@pradyumn.agrawal Not sure if i have got it right, but check this Workflow and check the input data that was assigned. Execute the Workflow. Check if the Output is the data that you need. I have altered the Input data by adding two more similar data.
It is working fine but the regular expression which you have used will be eligible for only one kind of data.
What if the data between two timestamps increased by 20 lines.
And log file contains more than 10,000 lines i want to get data after my filtered timestamp till next timestamp.
understand my requirement like
I am fetching some data from web and extracting the timestamp1 from that
now i have to check my log file that if the timestamp is available or not,
i searched timestamp1 in my log file which contains more than 10000 lines and have mutiple timestamps.
I want to extract the data from my timestamp1 to till next timestamp.