10-27-2010
How to filter a whole line using a word?
Hello Team,
I have a script in which more than 500 trigger statemetns are written.
i need to filter all lines from that script file which containts "CREATE TRIGGER" word in each line
is it possible using linux commands??
example:
CREATE TRIGGER S1.T1
...............
..............
.......
END
CREATE TRIGGER s2.t2
............
........
.......
...
END
..
..
..
..
out put should
CREATE TRIGGER s1.t1
CREATE TRIGGER s2.t2
.....
...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Greetings.
I am struggling with a shell script to make my life simpler, with a number of practical ways in which it could be used. I want to take a standard text file, and pull the 'n'th word from each line such as the first word from a text file.
I'm struggling to see how each line can be... (5 Replies)
Discussion started by: tricky
5 Replies
2. UNIX for Dummies Questions & Answers
Hey All,
On commad promt of a shell..
How can we move our cursor word by word.
Like Ctrl+A takes to the starting of the command...
Any shortcut like that..?
Thanks
pbsrinivas (1 Reply)
Discussion started by: pbsrinivas
1 Replies
3. Shell Programming and Scripting
i have this line
my,name,is,john
stored in a file d.sh and i wish to print the line as string..but im getting word by word...have tried this.........
for in $(cat $d.sh);
do
echo $i
done
but this is giving me
my
name
is
john (6 Replies)
Discussion started by: vadharah
6 Replies
4. UNIX for Advanced & Expert Users
Hi,
I am trying to filter the words from a file which contain 'abc'. But I am unable to. Could any one help me.
For eg: The file contents are
123ab 12hnj1 123abc456 123cgbcahjkf23 23134abchfhj43 gc32abc abc1 2abc3 sd uiguif fhwe 21242 uh123 jkcas124d123 u3hdbh23u ffsd8
Output... (3 Replies)
Discussion started by: venu_eie
3 Replies
5. Shell Programming and Scripting
Adding a word in front of a word of each line.In that line only one word will be there.
pl help:( (4 Replies)
Discussion started by: Ramesh Vellanki
4 Replies
6. UNIX for Dummies Questions & Answers
I have a File with the below contents
File1
I have no prior experience in unix. I have just started to work in unix.
My experience in unix is 0. My Total It exp is 3 yrs.
I need to replace the first word in each line with the last word for example
unix have no prior experience in... (2 Replies)
Discussion started by: kri_swami
2 Replies
7. Shell Programming and Scripting
i have a file in this pattern
MATCH1 word1 IMAGE word3 word4
MATCH2 word1 word2 word3 word4
MATCH2 word1 word2 word3 word4
MATCH2 word1 word2 word3 word4
MATCH2 word1 word2 word3 word4
MATCH1 word1 IMAGE word3 word4
MATCH2 word1 word2 word3 word4
MATCH2 word1 word2 word3 word4
MATCH2 word1... (7 Replies)
Discussion started by: bangaram
7 Replies
8. Shell Programming and Scripting
Hi All,
Hope you guys had a wonderful weekend
I have a scenario where in which I have to read a file line by line
and check for few words before redirecting to a file
I have searched the forum but,either those answers dint work (perhaps because of my wrong under standing of how IFS... (6 Replies)
Discussion started by: Kingcobra
6 Replies
9. Shell Programming and Scripting
I have a file: file.txt, which contains the following data in it.
This is a file, my name is Karl, what is this process, karl is karl junior, file is a test file, file's name is file.txt
My name is not Karl, my name is Karl Joey
What is your name?
Do you know your name and... (3 Replies)
Discussion started by: anuragpgtgerman
3 Replies
10. Shell Programming and Scripting
Hi Team,
I am trying hard to find a way I can filter a line as below:
If I have a line as
/abc /def 123:/ghi /jkl 456:/mno /pqrs 7890:/tuvw /xyz
I am expecting my output to be as below:
/abc /def /jkl /pqrs /xyz
basically I want to ignore anything preceding or succeeding colon... (2 Replies)
Discussion started by: SiddhVi
2 Replies
LEARN ABOUT CENTOS
alter_trigger
ALTER
TRIGGER(7) PostgreSQL 9.2.7 Documentation ALTER TRIGGER(7)
NAME
ALTER_TRIGGER - change the definition of a trigger
SYNOPSIS
ALTER TRIGGER name ON table_name RENAME TO new_name
DESCRIPTION
ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing
the trigger definition.
You must own the table on which the trigger acts to be allowed to change its properties.
PARAMETERS
name
The name of an existing trigger to alter.
table_name
The name of the table on which this trigger acts.
new_name
The new name for the trigger.
NOTES
The ability to temporarily enable or disable a trigger is provided by ALTER TABLE (ALTER_TABLE(7)), not by ALTER TRIGGER, because ALTER
TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.
EXAMPLES
To rename an existing trigger:
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
COMPATIBILITY
ALTER TRIGGER is a PostgreSQL extension of the SQL standard.
SEE ALSO
ALTER TABLE (ALTER_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 ALTER TRIGGER(7)