How to catch a two word keyword which may contain a new line(may include spaces or tab) in it?

Login or Register to Ask a Question and Join Our Community

How to catch a two word keyword which may contain a new line(may include spaces or tab) in it?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to catch a two word keyword which may contain a new line(may include spaces or tab) in it?

10-26-2012

Registered User

48, 0

Join Date: May 2011

Last Activity: 15 April 2020, 4:53 PM EDT

Posts: 48

Thanks Given: 28

Thanked 0 Times in 0 Posts

How to catch a two word keyword which may contain a new line(may include spaces or tab) in it?

How to catch a two word keyword which may contain a new line(may include spaces or tab) in it.
for example there is a file a.txt.

Code:

$more a.txt
create view 
as
(select  from
.........
..........
(   select
....
(
select
......
..
 
select only no (((
number
(             select
end

Code:

 grep "([[:space:]]*select" a.txt
output:
(select  from
(   select
(             select

but i want the 3rd select also to be caught(where there is a newline between "(" and "select" keyword)
i.e
(
select
what modification i should do in my grep command?

Last edited by jim mcnamara; 10-26-2012 at 05:52 PM..

neelmani

View Public Profile for neelmani

Find all posts by neelmani

10-26-2012

Registered User

440, 71

Join Date: Oct 2009

Last Activity: 26 June 2018, 6:52 PM EDT

Location: spaceBAR Central

Posts: 440

Thanks Given: 0

Thanked 71 Times in 70 Posts

Don't think I understand, check out the below:

Code:

$ cat t
create view
as
(select  from
.........
..........
(   select
....
(
select
......
..

select only no (((
number
(             select
end

This finds all of them:
$ grep "select" t
(select  from
(   select
select
select only no (((
(             select

spacebar

View Public Profile for spacebar

Find all posts by spacebar

10-26-2012

Moderator

3,689, 1,352

Join Date: Jan 2012

Last Activity: 22 August 2020, 11:29 PM EDT

Location: Galactic Empire

Posts: 3,689

Thanks Given: 268

Thanked 1,352 Times in 1,258 Posts

Code:

egrep "\([[:space:]]*select|select$" a.txt

Yoda

View Public Profile for Yoda

Visit Yoda's homepage!

Find all posts by Yoda

10-27-2012

Registered User

48, 0

Join Date: May 2011

Last Activity: 15 April 2020, 4:53 PM EDT

Posts: 48

Thanks Given: 28

Thanked 0 Times in 0 Posts

@spacebar Thanks for our reply. but i dont want all to be listed out. i want to catch a two word keyword(here it is "(" and "select" words) which may be seperated by a new line(may be searated by spaces or tab) . so "select only no (((" should not be there in the output.

@bipinajith

Code:

egrep "\([[:space:]]*select|select$" a.txt

in the second filter, you are assuming that it ends with "select" which is not the case always. The only goal is to catch a two word keyword(here it is "(" and "select" words) which may be seperated by a new line(may be searated by spaces or tab). for example b.txt .

Code:

more b.txt
(
select
....
(
select all
...
as 
select

(      select

output should be :

Code:

(
select
(
select all 
(           select

Last edited by Scrutinizer; 10-27-2012 at 07:52 AM.. Reason: code tags

neelmani

View Public Profile for neelmani

Find all posts by neelmani

10-27-2012

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

Try:

Code:

sed -n '/(/{/select/!N;//p;}' infile

Last edited by Scrutinizer; 10-27-2012 at 09:37 AM..

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

10-27-2012

Registered User

1,413, 498

Join Date: Mar 2012

Last Activity: 8 November 2019, 2:39 AM EST

Location: India

Posts: 1,413

Thanks Given: 101

Thanked 498 Times in 474 Posts

With a sed which supports bracket expressions:

Code:

sed -n ':strt
/([[:space:]]*select/{;p;b;}
/([[:space:]]*/{;N;b strt;}' file

Last edited by elixir_sinari; 10-27-2012 at 09:47 AM..

elixir_sinari

View Public Profile for elixir_sinari

Find all posts by elixir_sinari

10-28-2012

Registered User

48, 0

Join Date: May 2011

Last Activity: 15 April 2020, 4:53 PM EDT

Posts: 48

Thanks Given: 28

Thanked 0 Times in 0 Posts

@scrutinizer + sinari.. thanks for you reply. The sed command given by you is working for b.txt. But it will not work for all the cases to catch a two word keyword(here it is "(" and "select" words) which may be seperated by a new line(may be searated by spaces or tab) . for example

Code:

more c.txt
create view 
as
(select  from
.........
..........
(   select
....
(
select
......
..
 
select only no (((
number
(             select
 
.....
(
select all
.......
........
as (
select
........
 
end

the output should be:

Code:

(select  from
(   select
(
select
(             select
(
select all
as (
select

neelmani

View Public Profile for neelmani

Find all posts by neelmani

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to extract the word after a particular keyword throughout the file..

Hi Everyone, Need help in extracting the hostname from the below output. Expected output: DS-TESTB-GDS-1.TEST.ABC.COM DS-TESTB-GDS-2.TEST.ABC.COM .... ... /tmp $ cat -n /tmp/patchreport 1 /usr/bin/perl /admin/bin/patch/applyPatches.pl --apply_patches...

2. Shell Programming and Scripting

Removing tab spaces at the end of each line

I have a file which contains the data lines like below.I want to remove the tab spaces at the end of each line.I have tried with the command sed 's/\+$//' file.but it does not work.Can anyone help me on this? 15022 15022 15022 15022 15022 15022 15023 15023 15023 15023 15023 ...

3. Shell Programming and Scripting

Search for a Keyword in file and replace another keyword or add at the end of line

Hi I want to implement something like this: if( keyword1 exists) then check if(keyword2 exists in the same line) then replace keyword 2 with New_Keyword else Add New_Keyword at the end of line end if eg: Check for Keyword JUNGLE and add/replace...

4. Shell Programming and Scripting

How to get the next word which falls just after a keyword?

Hi friends, i just want to know the command though which i can get the next word which comes just after a particluar keyword. For example: suppose text.out is file which contains a pl/sql procedure . i want to find out the word which falls just after the "table1" keyword. Thank...

5. Shell Programming and Scripting

catch a particular word from a specific line -perlscript

Hi, App.log contains the data- ================================================= Value of DsRef =null Recovery File exixts Recovered readFile 20110509 17:00:00.369019 +0100s The DsRef Recovered from Recovery.txt file : 20110509 17:00:00.369019 +0100 Recovered from Recovery.txt file...

6. Shell Programming and Scripting

Include white spaces while using CUT command

Hi I tried to extract 19 characters (default) enclosed with in tag from a file using cut command. If the characters comprises of double space, the cut command gives the output with a single spacing. file 1 <name>Kumar Rajasekaran</name> cut -c7-26 "file1" the out put i received is ...

7. Shell Programming and Scripting

Removing blank spaces, tab spaces from file

Hello All, I am trying to remove all tabspaces and all blankspaces from my file using sed & awk, but not getting proper code. Please help me out. My file is like this (<b> means one blank space, <t> means one tab space)- $ cat file NARESH<b><b><b>KUMAR<t><t>PRADHAN...

8. Shell Programming and Scripting

Replace spaces between strings in a line with tab

Hi All I am having problem in substitution of any number of spaces, or a combination of space and tab in between strings in the lines of text file. Is there any way out in Perl? Please help me. e.g., Say the input is in the following format:- XX yyy zzz...

9. Shell Programming and Scripting

Replace only if the keyword is the first word in every line

How do I replace only if the keyword is at the begining of a line? Code: -- a = �This is a print statement� print a -- What if I want to replace print by #print only in the second line i.e only if the line starts with that keyword. Please help me out. I'm new to SED. -----Post...

10. Shell Programming and Scripting

How to include PDF file with spaces

I am able to include a pdf file as an attachment in an email using the following: echo "" > reports elm -s "RW100 PDF Reports" me@myemail.com < reports However, if I have a filename that contains some spaces, I'm not so lucky. I've tried: echo "" > reports but no luck. I keep getting...

Login or Register to Ask a Question