How to delete blank line/s before and after a search pattern?
Hi,
Test file x.txt below. This file is generated by a program that I unfortunately do not have control on how it gets presented/generated.
Code:
create 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 PACKAGE BODY "XXX_MORE_HERE" wrapped
...
...
...
What I am wanting to do is below:
Replace any line that starts with create to be create or replace.
Search for the REUSE SETTINGS TIMESTAMP string and delete all the blank lines that precedes it and any blank lines after it.
At the moment, I am deleting all blank lines using
Code:
sed 's/CREATE/CREATE or REPLACE/ig' x.txt | sed '/^$/d'
The main reason I am wanting to retain some of the blank lines is for clarify and to make it easier reading the code.
While deleting all the blank lines work, it makes it difficult to read the generated code. Not removing the blank lines in the REUSE SETTINGS section gives error when running the SQL script.
If I can't use sed/awk to do what's required maybe I should be write some sort of cleansing script?
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)
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)
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)
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)
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)
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)
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)
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)
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
test::inline::content
Test::Inline::Content(3pm) User Contributed Perl Documentation Test::Inline::Content(3pm)NAME
Test::Inline::Content - Test::Inline 2 Content Handlers
DESCRIPTION
One problem with the initial versions of Test::Inline 2 was the method by which it generated the script contents.
"Test::Inline::Content" provides a basic API by which more sophisticated extensions can be written to control the content of the generated
scripts.
METHODS
new
A default implementation of the "new" method is provided that takes no parameters and creates a default (empty) object.
Returns a new "Test::Inline::Content" object.
process $Inline $Script
The "process" method does the work of generating the script content. It takes as argument the parent Test::Inline object, and the completed
Test::Inline::Script object for which the file is to be generated.
The default implementation returns only an empty script that dies with an appropriate error message.
Returns the content of the script as a string, or "undef" on error.
SUPPORT
See the main SUPPORT section.
AUTHOR
Adam Kennedy <adamk@cpan.org>, <http://ali.as/>
COPYRIGHT
Copyright 2004 - 2010 Adam Kennedy.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
perl v5.12.4 2010-11-22 Test::Inline::Content(3pm)
03-23-2016
