Shell Programming and Scripting

I have a file
CREATE TABLE DDD_EXT --- 1000
(
val u1
val u1
);
CREATE TABLE dsdasd_EXT --- 1323
(
val u1
val u1
);
CREATE TABLE AAAAAA_EXT --- 1222
(
val u1
val u1
);
CREATE TABLE E_EXT --- 11
(
val u1
val u1
);
CREATE TABLE TRTERTRE_EXT --- 0
(
val u1
val u1
);
CREATE TABLE GRGY_EXT --- 0
(
val u1
val u1
);
CREATE TABLE RRRR_EXT --- 123
(
val u1
val u1
);

How can obtain the below output
insert into test_table values ( 'DDD' , NULL, 1000 );
insert into test_table values ( 'dsdasd, NULL, 1323);
insert into test_table values ( 'AAAAAA, NULL,1222 );
insert into test_table values ( 'E', NULL, 11);
insert into test_table values ( 'TRTERTRE, NULL, 0);
insert into test_table values ( 'GRGY, NULL, 0);
insert into test_table values ( 'RRRR, NULL, 123);

awk /CREATE/{printf ("insert into test_table values('%s', NULL, %d)\n", $1, $3);} FILENAME

test your script.

@OP

Code:

awk  'BEGIN{FS="[ ]|_"}/CREATE/{printf ("insert into test_table values('%s', NULL, %d)\n", $3, $NF);}'  file