regular expression across some lines

ynixon · #1 (**permalink**) 05-24-2007

I am trying to use regular expression to identify ONLY the commands that hasn't the word "tablespace" within it. a command starts with "create table" and ends with ; (semicolon)

example file:

Code:

create table first tablespace ;
create table second
(
  BBL_CUSTOMER_NAME      VARCHAR2(32),
a tablespace af
);
create table third
(
  BBL_CUSTOMER_NAME      VARCHAR2(32),
);
create table 
forth
(
  BBL_CUSTOMER_NAME      VARCHAR2(32) );

the match should be:

Code:

create table third
(
  BBL_CUSTOMER_NAME      VARCHAR2(32),
);
create table 
forth
(
  BBL_CUSTOMER_NAME      VARCHAR2(32) );

HELP ME

aigles · #2 (**permalink**) 05-24-2007

You can try something like that :

Code:

awk '
   BEGIN { 
      RS=ORS=";\n"
   }
   /create/ && ! /tablespace/ {
      sub(/^\n*/, "");
      print
   }
    ' inputfile

Jean-Pierre.

anbu23 · #3 (**permalink**) 05-24-2007

Code:

awk -v RS=";\n" -v ORS=";\n" ' !/tablespace/ ' filename

ynixon · #4 (**permalink**) 05-24-2007

I'd like to try using only grep

drl · #5 (**permalink**) 05-24-2007

Hi.

I think that grep will not cross newlines, so that you would need to place your commands each on a single line. There is a note in my man grep page about using perl regular expressions, but that it is undocumented. The awk and perl scripts can make use of settable record boundaries.

Here's a perl quickie:

Code:

#!/bin/sh

# @(#) s1       Demonstrate perl quickie for unmatched string across lines.

FILE=${1-data1}

perl -wn -e 'BEGIN{$/=";"} print if not /tablespace/' $FILE

exit 0

And running this on your sample contained in file data1:

Code:

% ./s1

create table third
(
  BBL_CUSTOMER_NAME      VARCHAR2(32),
);
create table
forth
(
  BBL_CUSTOMER_NAME      VARCHAR2(32) );

Best wishes ... cheers, drl

vgersh99 · #6 (**permalink**) 05-24-2007

Quote:

Originally Posted by ynixon

I'd like to try using only grep

why is that?

ynixon · #7 (**permalink**) 05-24-2007

Quote:

Originally Posted by vgersh99

why is that?

unfortunately the final solution will be used in windows environment

,
I am not planning to use Perl because it will need installations in all PCs.
the nuances of regular expression is almost the same in all other languages.
So the convenient solution will be vbscript.

Since I know you are ACEs I decided to ask you

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
regular expression [^ ]	iengca	Shell Programming and Scripting	9	06-18-2008 09:45 AM
Need a regular expression	tony3101	Shell Programming and Scripting	4	06-05-2008 03:13 AM
regular expression and awk	nickg	UNIX for Dummies Questions & Answers	2	08-16-2007 05:23 PM
Regular Expression	edog	UNIX for Dummies Questions & Answers	5	12-04-2003 02:58 PM
Regular Expression + Aritmetical Expression	Z0mby	Shell Programming and Scripting	2	05-21-2002 10:59 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: