From: Ahmet Kilic <ahmedkilic@...>
Date: 2009-08-31T18:17:07+09:00
Subject: Sql script with regex

"INSERT INTO CBM_CT_BY_CLT ( "\
            "       CST_CD, "\
            "       BLK_REG_SEQ, "\
            "       BLK_REG_DT, "\
            "       DEL_FLG "\
            ") "\
            "VALUES ( "\.........

how can I get the table name(CBM_CT_BY_CLT) and column name ( CST_CD
...) from this sql script?
It contains spaces and the script is line by line.
I am trying like this  but it is no useless
columnname = text.scan(/"\s+(.*?)\s+"\\/)
please help...
-- 
Posted via http://www.ruby-forum.com/.