From: Ahmet Kilic <ahmedkilic@...>
Date: 2009-09-01T13:00:01+09:00
Subject: Re: Sql script with regex

Pascal J. Bourguignon wrote:
> Ahmet Kilic <ahmedkilic@gmail.com> writes:
> 
>> 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+"\\/)
> 
> You will have to write a SQL parser.
> 
> Of course, you may try to do a half-assed job with regular
> expressions, but SQL is a language with a context-free grammar, so you
> need a parser.

I think SQL parser is very deep for me.
I got it with regex. Thank you very much.
-- 
Posted via http://www.ruby-forum.com/.