[Gambas-user] traslate grep expresion to detect COMMENT in line sql

[Fernando Cabral]

2017-07-28 12:50 GMT-03:00 PICCORO McKAY Lenz <mckaygerhard at ...626...>:

> wow! i must made a string search procedure until "comment" was find.. !
>
> i think that but i also think that a reg expresion must be better with pcre
> component!
>

My suggestion it to be used with pcre componte. I only gave you the search
and replace regular expression. Something like

NewLine  = RegExp.Replace(OldLIne,
"^(.*?) COMMENT +?(".*?")(,.*?)", "&1 \*&2*/&3", RegExp.UTF8)

But, since I presume you'll be using it several times, then it will be more
efficiente if you compile it first.

- fernando

Lenz McKAY Gerardo (PICCORO)
> http://qgqlochekone.blogspot.com
>
> 2017-07-28 11:34 GMT-04:00 Fernando Cabral <fernandojosecabral at ...626...>:
>
> > 2017-07-28 11:57 GMT-03:00 PICCORO McKAY Lenz <mckaygerhard at ...626...>:
> >
> > >
> > > my target objetive it parse a text/line like this:
> > >
> > >  fiel1 TEXT COMMENT "coment fiel1" , field2 TEXT, fiel3 TEXT
> > >  fiel4 NUMBER(10,2), fiel5 TEXT COMMENT "pepepeep",
> > >  fiel6 TEXT
> > >
> > > into this:
> > >
> > >  fiel1 TEXT /* coment fiel1*/ , field2 TEXT, fiel3 TEXT
> > >  fiel4 NUMBER(10,2), fiel5 TEXT /*pepepeep*/,
> > >  fiel6 TEXT
> > >
> >
> > Let me see if I have understood this well enough:
> > a) find the word " COMMENT " (whitespace before and after), followed by
> > whatever till you find a "," (comma)
> > b) Delede " COMMENT " and put "whatever" between "/*" and "*/"
> > c) Leave untouched whatever is after the first "," (comma) including the
> > comma itself.
> >
> > Is that right? If it is, you should start by compiling this regular
> > expression:
> >
> > "^(.*?) COMMENT +?(".*?")(,.*?)"
> >
> > And the replace by: "&1 \*&2*/&3"  (scape as needed) and this should
> work.
> >
> > what it does:
> > a) from the start of the line, find whatever exists until the expression
> "
> > COMMENT " -- which should not be included.
> > b) Save that firt part into the buffer number 1
> > c) Skip til after the last white space after " COMMENT " - throw that
> away
> > d) save the next portion between double quotes and save into buffer
> number
> > 2
> > e) Save next portion into buffer number 3
> >
> > Put back the contents from buffer 1, add "\*", put back the contents of
> > buffer 2, add "*/" and then put back the contents of buffer number 3.
> >
> > You may have to tinker around a little, but I think this contains the
> basic
> > ideia.
> >
> > - fernando
> >
> >
> >
> >
> > Lenz McKAY Gerardo (PICCORO)
> >
> > > http://qgqlochekone.blogspot.com
> > > ------------------------------------------------------------
> > > ------------------
> > > Check out the vibrant tech community on one of the world's most
> > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> > > _______________________________________________
> > > Gambas-user mailing list
> > > Gambas-user at lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/gambas-user
> > >
> >
> >
> >
> > --
> > Fernando Cabral
> > Blogue: http://fernandocabral.org
> > Twitter: http://twitter.com/fjcabral
> > e-mail: fernandojosecabral at ...626...
> > Facebook: f at ...3654...
> > Telegram: +55 (37) 99988-8868
> > Wickr ID: fernandocabral
> > WhatsApp: +55 (37) 99988-8868
> > Skype:  fernandojosecabral
> > Telefone fixo: +55 (37) 3521-2183
> > Telefone celular: +55 (37) 99988-8868
> >
> > Enquanto houver no mundo uma só pessoa sem casa ou sem alimentos,
> > nenhum político ou cientista poderá se gabar de nada.
> > ------------------------------------------------------------
> > ------------------
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> >
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>



-- 
Fernando Cabral
Blogue: http://fernandocabral.org
Twitter: http://twitter.com/fjcabral
e-mail: fernandojosecabral at ...626...
Facebook: f at ...3654...
Telegram: +55 (37) 99988-8868
Wickr ID: fernandocabral
WhatsApp: +55 (37) 99988-8868
Skype:  fernandojosecabral
Telefone fixo: +55 (37) 3521-2183
Telefone celular: +55 (37) 99988-8868

Enquanto houver no mundo uma só pessoa sem casa ou sem alimentos,
nenhum político ou cientista poderá se gabar de nada.