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

Fernando Cabral fernandojosecabral at ...626...
Fri Jul 28 17:34:43 CEST 2017


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.



More information about the User mailing list