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.
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
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 SUSE
alter_operator
ALTER OPERATOR(7) SQL Commands ALTER OPERATOR(7)NAME
ALTER OPERATOR - change the definition of an operator
SYNOPSIS
ALTER OPERATOR name ( { lefttype | NONE } , { righttype | NONE } ) OWNER TO newowner
DESCRIPTION
ALTER OPERATOR changes the definition of an operator. The only currently available functionality is to change the owner of the operator.
You must own the operator to use ALTER OPERATOR. To alter the owner, you must also be a direct or indirect member of the new owning role,
and that role must have CREATE privilege on the operator's schema. (These restrictions enforce that altering the owner doesn't do anything
you couldn't do by dropping and recreating the operator. However, a superuser can alter ownership of any operator anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing operator.
lefttype
The data type of the operator's left operand; write NONE if the operator has no left operand.
righttype
The data type of the operator's right operand; write NONE if the operator has no right operand.
newowner
The new owner of the operator.
EXAMPLES
Change the owner of a custom operator a @@ b for type text:
ALTER OPERATOR @@ (text, text) OWNER TO joe;
COMPATIBILITY
There is no ALTER OPERATOR statement in the SQL standard.
SEE ALSO
CREATE OPERATOR [create_operator(7)], DROP OPERATOR [drop_operator(7)]
SQL - Language Statements 2010-05-14 ALTER OPERATOR(7)