Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to delete blank line/s before and after a search pattern?
Top Forums UNIX for Dummies Questions & Answers How to delete blank line/s before and after a search pattern? Post 302969579 by newbie_01 on Thursday 24th of March 2016 07:57:22 AM
Old 03-24-2016
Hi,

No objection to a non-one liner. No need to remove the space in front of the REUSE. I will try this out. Thanks.

---------- Post updated at 06:57 AM ---------- Previous update was at 06:36 AM ----------

Hi Don,

Thanks for replying. Please find answers below.
  1. All strings being matched are case insensitive.
    Answer: YES
  2. If a line contains create starting is column 1, that string should be changed to CREATE or REPLACE (even if a line currently starts with the string create or replace .
    Answer    : hmmm, very, very good thinking. I never thought of that. The answer for that is NO, if it already contains create or replace, then skip it, no change required.
  3. You want to remove every set of adjacent blank lines immediately preceding and immediately following any line that contains the string REUSE SETTINGS . All other blank lines should be copied from the input to the output unchanged.
    Answer: All blank lines preceding the REUSE SETTINGS and blank lines after it up until the next /, will have to be removed.
The output that I am expecting to get is as below:

Code:
CREATE or REPLACE PACKAGE "XXX_INTERFACE_DEFECT_RPT_TEST" is

TYPE refCursor IS REF CURSOR;

Function queryRecords (
  p_status varchar2,
...
...
...
) return refCursor;

Function getQueryRecords(
...
...
...

ALTER PACKAGE "XXX"."XXX_INTERFACE_DEFECT_RPT_TEST"
  COMPILE SPECIFICATION
    PLSQL_OPTIMIZE_LEVEL=  2
    PLSQL_CODE_TYPE=  INTERPRETED
    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE'
 REUSE SETTINGS TIMESTAMP '2015-06-24 23:45:01'
/

ALTER PACKAGE "XXX"."XXX_INTERFACE_PRODUCTION_WO"
  COMPILE SPECIFICATION
    PLSQL_OPTIMIZE_LEVEL=  2
    PLSQL_CODE_TYPE=  INTERPRETED
    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE'
 REUSE SETTINGS TIMESTAMP '2015-06-24 23:45:17'
/

ALTER PACKAGE "XXX"."XXX_INTERFACE_PRODUCTION_WO"
  COMPILE SPECIFICATION
    PLSQL_OPTIMIZE_LEVEL=  2
    PLSQL_CODE_TYPE=  INTERPRETED
    PLSQL_DEBUG=  FALSE    PLSCOPE_SETTINGS=  'IDENTIFIERS:NONE'
 REUSE SETTINGS TIMESTAMP '2015-06-24 23:45:17'
/

-- new object type path: SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
CREATE or REPLACE PACKAGE BODY "XXX_MORE_HERE" wrapped
...
...
...

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete a block of text delimited by blank lines when pattern is found

I have a file which contains blocks of text - each block is a multi-lines text delimited by blank lines eg. <blank line> several lines of text ... pattern found on this line several more lines of text ... <blank line> How do you delete the block of text (including the blank lines) when... (17 Replies)
Discussion started by: gleu
17 Replies

2. Shell Programming and Scripting

Multile Pattern Search in a same line and delete

HI Gurus, I need to delete a line from a syslog file, if it matches three conditions. Say for ex., if the device name is device.name.com and if it contains the syslog message PAGP-5-PORTFROMSTP in between the time period 00:00:00 to 04:00:00, then the particular line has to be deleted from... (2 Replies)
Discussion started by: sasree76
2 Replies

3. Shell Programming and Scripting

how to delete a first blank line from the file

I have a file which has the first blank line: sundev22$cat /t1/bin/startallocs /t1/bin/startallocsys 123 sundev22$ Is there a command to remove this first blank line? Thanks for help -A (4 Replies)
Discussion started by: aoussenko
4 Replies

4. Shell Programming and Scripting

sed: delete regex line and next line if blank

Hi, I want to write a sed script which from batiato: batiato/giubbe: pip_b.2.txt pip_b.3.txt pip_b.3mmm.txt bennato: bennato/peterpan: 123.txt consoli: pip_a.12.txt daniele: (2 Replies)
Discussion started by: one71
2 Replies

5. Shell Programming and Scripting

Delete last blank line.

I need to delete the last line only if its blank not otherwise. (3 Replies)
Discussion started by: dinjo_jo
3 Replies

6. Shell Programming and Scripting

awk delete/remove rest of line on multiple search pattern

Need to remove rest of line after the equals sign on search pattern from the searchfile. Can anybody help. Couldn't find any similar example in the forum: infile: 64_1535: Delm. = 86 var, aaga 64_1535: Fran. = 57 ex. ccc 64_1639: Feb. = 26 (link). def 64_1817: mar. = 3/4. drz ... (7 Replies)
Discussion started by: sdf
7 Replies

7. Shell Programming and Scripting

Need help to replace a pattern with a blank line

Need help to replace the line beginning with tcp_sendspace with a blank line. # cat if en0: flags=1e080863,480<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),CHAIN> inet 10.27.53.21 netmask 0xffffff00 broadcast 10.207.52.255 inet... (11 Replies)
Discussion started by: sags007_99
11 Replies

8. Shell Programming and Scripting

Sed delete blank lines upto first pattern match

Hi Im trying to do the following in sed. I want to delete any blank line at the start of a file until it matches a pattern and then stops. for example: Input output: I have got it to work within a range of two patterns with the following: sed '/1/,/pattern/{/^]*$/d}' The... (2 Replies)
Discussion started by: duonut
2 Replies

9. Homework & Coursework Questions

sed Multiple Pattern search and delete the line

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I have file which has got the following content sam 123 LD 41 sam 234 kp sam LD 41 kam pu sam LD 61 Now... (1 Reply)
Discussion started by: muchyog
1 Replies

10. Shell Programming and Scripting

String search and print next all lines in one line until blank line

Dear all I want to search special string in file and then print next all line in one line until blank lines come. Help me plz for same. My input file and desire op file is as under. i/p file: A1/EXT "BSCABD1_21233G1" 757 130823 1157 RADIO X-CEIVER ADMINISTRATION BTS EXTERNAL FAULT ... (7 Replies)
Discussion started by: jaydeep_sadaria
7 Replies

LEARN ABOUT DEBIAN

osd_cat

XOSD(1) 						      General Commands Manual							   XOSD(1)

NAME

       osd_cat - X on-screen file displayer

SYNOPSIS

       osd_cat [OPTION] [FILE]...
       osd_cat -b percentage|slider [OPTION]

DESCRIPTION

       Display FILE, or standard input, on X screen.

       -p, --pos=POS
	      This option tells osd_cat where to display the text. POS can be top, middle, or bottom. The default is top.

       -o, --offset=OFFSET
	      This option specifies the offset from the top or bottom of screen the text is displayed. The default is 0.

       -A, --align=ALIGN
	      This option tells osd_cat where to display the text. ALIGN can be left, right or center. The default is left.

       -i, --indent=OFFSET
	      This option specifies the INDENT from the left of screen the text is displayed. The default is 0.

       -f, --font=FONT
	      This option specifies the FONT to be used for displaying the text. The default is fixed.

       -c, --color=COLOR
	      This option specifies the COLOR to be used for displaying the text. The default is red.

       -d, --delay=TIME
	      This option specifies the number of seconds the text is displayed. The default is 5 seconds.

       -l, --lines=LINES
	      This option specifies the number of LINES to scroll the display over. The default is 5.

       -s, --shadow=OFFSET
	      This option specifies the OFFSET of the text shadow. The default is 0, which means no text shadow is created.

       -S, --shadowcolour=COLOUR
	      This option specifies the COLOUR of the text shadow.  The default is black.

       -O, --outline=WIDTH
	      This option specifies the WIDTH of the text outline.  The default is 0, which is no outline.

       -u, --outlinecolour=COLOUR
	      This option specifies the COLOUR of the text outline.  The default is black.

       -a, --age[=SCROLL_AGE]
	      This  option  affects  screen  redrawing.  If SCROLL_AGE seconds pass before a new line is ready (for example, you're reading from a
	      pipe), all lines are cleared at once instead of being scrolled off as new lines replace old lines. The default is 0.
	      When no SCROLL_AGE is explicitly given, the current value from DELAY is used.

       -w, --wait
	      This option also affects screen redrawing. When there is data ready to be put on screen, this option  will  cause  osd_cat  to  wait
	      until the display is clear. An alternative to scrolling.

       -b, --barmode=TYPE
	      Lets  you  display a percentage or slider bar instead of just text.  TYPE may be percentage or slider.  In this mode no text is read
	      from any file, but the following options can be used:

       -P, --percentage=PERCENTAGE
	      This option specified the position of the percentage / slider bar.  PERCENTAGE may be in the range from 0 to 100, the default is 50.

       -T, --text=TEXT
	      This option specifies an optional TEXT which gets displayed above the percentage bar.  The default is empty, so no  additional  text
	      is displayed.

       -h, --help
	      display help (which is often more up to date) and exit

       With no FILE, or when FILE is -, read standard input.

AUTHOR

       Martijn	van  de  Streek  <martijn@foodfight.org>,  Some  patching  done  by  Malcolm  Valentine  <farkit@iprimus.com.au>  and  Tim  Wright
       <tim@ignavus.net>.
       xosd was written by Andre Renaud <andre@ignavus.net> and is maintained by Tim Wright <tim@ignavus.net>

SEE ALSO

       More   information   on	 the   X   OSD	 Library   and	 its	author	  can	 be    found	on    http://www.ignavus.net/software.html
       <http://www.ignavus.net/software.html>

COPYRIGHT

       It is distributed under the GNU General Public License.

X OSD cat							   January 2001 							   XOSD(1)
All times are GMT -4. The time now is 10:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy