Programming

sed 's#.*);#replace string#' file

CREATE TABLE TEST.TEST 
(
ID_SOGGETTO BIGINT NOT NULL,
ENTE VARCHAR(64))
INDEX ( ENTE )
UNIQUE PRIMARY INDEX ( ID_SOGGETTO ,ENTE );

sed 's/^.*);/replacement;/' file

$
$ cat -n f84
     1  CREATE TABLE TEST.TEST1
     2  (
     3  ID_SOGGETTO BIGINT NOT NULL,
     4  ENTE VARCHAR(64))
     5  UNIQUE PRIMARY INDEX ( ID_SOGGETTO ,ENTE );
     6
     7  CREATE TABLE TEST.TEST2
     8  (
     9  ID_SOGGETTO BIGINT NOT NULL,
    10  ENTE VARCHAR(64))
    11  INDEX ( ENTE )
    12  UNIQUE PRIMARY INDEX ( ID_SOGGETTO ,ENTE );
    13
$
$
$ perl -lne 'BEGIN {undef $/; $rpl="REPLACEMENT_TEXT_HERE"} while(/(^CREATE.*?\(.*?\)$)(.*?\);)/msg){print "$1\n$rpl\n"}' f84
CREATE TABLE TEST.TEST1
(
ID_SOGGETTO BIGINT NOT NULL,
ENTE VARCHAR(64))
REPLACEMENT_TEXT_HERE
 
CREATE TABLE TEST.TEST2
(
ID_SOGGETTO BIGINT NOT NULL,
ENTE VARCHAR(64))
REPLACEMENT_TEXT_HERE
 
$
$