sed print between 2 patterns only last occurence Post: 302725927

Sponsored Content

Top Forums Shell Programming and Scripting sed print between 2 patterns only last occurence Post 302725927 by durden_tyler on Saturday 3rd of November 2012 12:50:41 AM

11-03-2012

Registered User

Code:

$
$
$ cat -n f16
     1  index sql
     2
     3  *** Index has been created.
     4  *** Total elapsed time was 8 seconds.
     5
     6
     7  +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
     8
     9  index from 1
    10
    11  *** Index has been created.
    12  *** Total elapsed time was 2 seconds.
    13
    14
    15  +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
    16  table from 2
    17
    18  *** Index has been created.
    19  *** Total elapsed time was 2 seconds.
    20
    21
    22  +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
    23  sql create from 1
    24
    25  *** Query completed. One row found. 3 columns returned.
    26  *** Total elapsed time was 1 second.
    27
    28  abc def ghi
    29  --------- ---------- ----------
    30  123 456 789
    31
    32  +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
    33
    34  .IF ACTIVITYCOUNT > 0 THEN .QUIT 600;
    35  .QUIT 600;
    36  *** You are now logged off from the DBC.
    37  *** Exiting BTEQ...
    38  *** RC (return code) = 600
    39  returncode is 600
$
$
$ perl -0ne 'while(/Total elapsed.*?\.\n(.*?-\+-)\n/sg){$x=$1} END{print $x,"\n"}' f16

abc def ghi
--------- ---------- ----------
123 456 789

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
$
$
$

tyler_durden

durden_tyler

View Public Profile for durden_tyler

Find all posts by durden_tyler

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sed/awk print between different patterns the first occurrence

Thanks for the help yesterday. I have a little modification today, I am trying the following: i have a log file of a webbap which logs in the following pattern: 2011-08-14 21:10:04,535 blablabla ERROR Exception1 blablabla bla bla bla bla 2011-08-14...

2. Shell Programming and Scripting

[Solved] Sed/awk print between patterns the first occurrence

Guys, I am trying the following: i have a log file of a webbap which logs in the following pattern: 2011-08-14 21:10:04,535 blablabla ERROR blablabla bla bla bla bla 2011-08-14 21:10:04,535 blablabla ERROR blablabla bla bla bla ...

3. Shell Programming and Scripting

How to get line after occurence of sequence of patterns

In the past I needed a help with the problem how to search for pattern after the occurence of another pattern which is described in this thread: https://www.unix.com/shell-programmin...-pattern1.html Now I would need something quite similar, only the pattern which is to be searched must be...

4. Shell Programming and Scripting

Retrieve lines that match any occurence in a list of patterns

I have two files. The first containing a header and six columns of data. Example file 1: Number SNP ID dbSNP RS ID Chromosome Result_Call Physical Position 787066 SNP_A-8575395 RS6650104 1 NOCALL 564477 786872 SNP_A-8575125 RS10458597 1 AA ...

5. UNIX for Dummies Questions & Answers

How to print first occurence

Hi there, how can i print the first pattern occurrence in a .log file? I want to print the filename of the first 17262? I tried but all I can do is print all the lines with the number 17262? I tried using awk and sed but nothing!:wall: I just want filename! Here�s an example: 17259...

6. Shell Programming and Scripting

Print mutliple patterns in a line using sed

Hi, I am trying to print multiple patterns in a line using sed. But it is printing only the last occurance of a pattern. If the line is the the output should be Lookup Procedure|Stored proc But the output I am getting is Stored proc The code I am using is echo...

7. Shell Programming and Scripting

Print between patterns - first occurence, second occurence etc

I have a file # cat asasas AAAAAA 11 22 33 44 BBBBB NILNILNIL AAAAAA 22 33 44 55 66 77 88 BBBBB NILNILNIL

8. Shell Programming and Scripting

Grab nth occurence in between two patterns using awk or sed

Hi , I have an issue where I want to parse through the output from a file and I want to grab the nth occurrence of text in between two patterns preferably using awk or sed ! TICKET NBR : 1 !GSI : 102 ! 3100.2.112.1 11/06/2013 15:56:29 ! 3100.2.22.3 98 ! 3100.2.134.2...

9. UNIX for Advanced & Expert Users

Get the first occurence between two patterns

I have an output file which gives me the timely status of a server. Sample file: March 11 2014 21:10, 1, 2, 3, 4, 5, 6, 7, 8, 9, x, y, z... 21:05, 1, 2, 3, 4, 5, 6, 7, 8, 9, x, y, z... 21:00, 1, 2, 3, 4,...

10. Shell Programming and Scripting

Find matched patterns and print them with other patterns not the whole line

Hi, I am trying to extract some patterns from a line. The input file is space delimited and i could not use column to get value after "IN" or "OUT" patterns as there could be multiple white spaces before the next digits that i need to print in the output file . I need to print 3 patterns in a...

LEARN ABOUT DEBIAN

xacobeo::timer

Xacobeo::Timer(3pm)					User Contributed Perl Documentation				       Xacobeo::Timer(3pm)

NAME

       Xacobeo::Timer - A custom made timer.

SYNOPSIS

	       use Xacobeo::Timer;

	       # As a one time use
	       my $timer = Xacobeo::Timer->start("Long operation");
	       do_long_operation();
	       $timer->elapsed(); # Displays the time elapsed

	       # A simple stop watch (the destructor displays the time elapsed)
	       my $TIMER = Xacobeo::Timer->new("Method calls");
	       sub hotspot {
		       $TIMER->start();
		       # Very slow stuff here
		       $TIMER->stop();
	       }

DESCRIPTION

       This package provides a very simple timer. This timer is used for finding hot spots in the application.

       The timer is quite simple it provides the method "start" that starts the timer and the method "stop" that stops the timer and accumulates
       the elapsed time.  The method "show" can be used to print the time elapsed so far while the method "elapsed" returns the time elapsed so
       far.

       When an instance of this class dies (because it was undefed or collected by the garbage collector) the builtin Perl desctrutor will
       automatically call the method "show". But if the method show or elapsed was called during the lifetime of the instance then the destructor
       will not invoke the method show.

METHODS

       The package defines the following methods:

   new
       Creates a new Timer.

       Parameters:

       o   $name (Optional)

	   The name of the timer.

   start
       Starts the timer. If this sub is called without a blessed instance then a new Timer will be created.

       Parameters:

       o   $name (optional)

	   The name is used only when called without a blessed instance.

   stop
       Stops the timer and adds accumulates the elapsed time. If the timer wasn't started previously this results in a no-op.

   show
       Prints the elapsed time. This method stops the timer if it was started previously and wasn't stopped.

   elapsed
       Returns the total time elapsed so far. If the timer was already started the pending time will not be taking into account.

AUTHORS

       Emmanuel Rodriguez <potyl@cpan.org>.

COPYRIGHT AND LICENSE

       Copyright (C) 2008,2009 by Emmanuel Rodriguez.

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or,
       at your option, any later version of Perl 5 you may have available.

perl v5.14.2							    2011-11-16						       Xacobeo::Timer(3pm)