Shell Programming and Scripting

Hi ,
Can some body help me why CREATE TABLE is not printing in my out put for the below code?

I tried the same but still out put is not accurate.

Code:

sed -n '
  1d
  s/^\([^ ]\{1,33\} \)\(.*\)/CREATE TABLE "("\1(\2","/
  :loop
  ${
    s/,$/ );/
    p
    }
  N
  s/\n\(.*\)/ \1,/
  b loop
 ' schema_file.txt

out put:

Code:

TAB1 COL1 INTEGER COL2 INTEGER, COL3 INTEGER, COL4 INTEGER, );

please explain more.

A txt file is having the columns like this
TABLENAME COLUMNS DATATYPE
TAB1 COL1 INTEGER
COL2 INTEGER
COL3 INTEGER
COL4 INTEGER


printf should be

CREATE TABLE TAB1 (COL INTEGER,COL2,INTEGER,COL3,INTEGER,COL4 INTEGER);

when i tried the above sed the CREATE TABLE is not printing...

Regards

For input file

use following command

to generate following output

Hello panyam ,
Thanks for your help its working for me.

Is there any possiblity to extend this code like ...if we have input file like.

TAB1 COL1 DATATYP1 NULL
COL2 DATA TYP2 NOT NULL
COL3 DAT TYPE3 NOT NULL
..
..
COL N
out put should be

CREATE TABLE (COL1 DATATYPE1 NULL,COL2 DATATYPE2 NOT NULL,COL3 DATATYPE3 ....COL N DATA TYPEN NOT NULL);

because i have a raw Excel sheet which has columns like the above format using that Excel sheet i need to prepare a CREATE TABLE statemetns for all entries of Excel.so i am copying manually each table contenet in a txt file so that using this AWK command i can prepare a DDL for all tables at one shot.

Regards

For your current input,

this should work fine: