Shell Programming and Scripting

MONDAY###SELECT BLAH,BLAH,... FROM TABSCHEMA1.TABNAME1 WITH UR
 SUNDAY###SELECT BLAH,BLAH,... FROM TABSCHEMA2.TABNAME2 WHERE BLAH=1 WITH UR

 cat <File name> | awk -F###<......>
 if Day = Monday
 then
 We need to get  TABSCHEMA1 and TABNAME1 in separate variables
 Later
 We use those variable again in other statement
 fi

awk -F 'FROM ' '
/MONDAY###/ && NF > 1 {
	if(match($2, /[.][^ ]* /)) {
		scheme = substr($2, 1, RSTART - 1)
		name = substr($2, RSTART + 1, RLENGTH - 1)
		printf("Line %d: scheme=%s, name=%s\n", NR, scheme, name)
	}
}' "input file"

Line 1: scheme=TABSCHEMA1, name=TABNAME1

 cat <File name> | awk -F###<......>
 if Day = Monday
 then
 We need to get  TABSCHEMA1 and TABNAME1 in separate variables
 Later
 We use those variable again in other statement
 fi

#!/usr/bin/perl -w
# Usage: perl regex.pl file.log
use strict;

my $file = shift;
my $fh = undef;

open ($fh, '<', $file) or die $!;

while (<$fh>)
{
 chomp;
 print "$1\n" if ($_ =~ /.*?FROM\s+(\S+)\s+.*/) 
}

__DATA__
SELECT BLAH,BLAH,... FROM TABSCHEMA1.TABSCHEMA1 WITH UR
SELECT BLAH,BLAH,... FROM TABSCHEMA2.TABSCHEMA2 WHERE BLAH=1 WITH UR

__RESULT__
TABSCHEMA1.TABSCHEMA1
TABSCHEMA2.TABSCHEMA2