Regular expression - find a regular expression in vim

Question

The original text is simplified as follows (several table creation statements, some tables have the same fields): {code...} I need to select the table creation statements with field2 field in the table, that is, select the following text { Code...} I thought of a regular CREATE\_.\{-}F_class_type\_.\{-}ENGIN...

ringa_lee · Answer

I checked the regular rules again and found that using negative lookaround can solve this problem.
Post the correct regex first: vCREATE(_.(CREATE)@!){-}field2_.{-}ENGINE.*

Explain it, it will also be convenient for you to check later
v: No backslash is required for any metacharactersv：任何元字符都不用加反斜杠
_.：包括换行符的所有字符
(CREATE)@!：顺序否定环视
(_.(CREATE)@!){-}：非贪婪匹配任意字符，并且匹配出的结果中不含有CREATE_.: All characters including line breaks

( CREATE)@!: Sequential negative lookaround

(_.(CREATE)@!){-}: Non-greedy matching of any characters, and the matched result does not contain CREATEstrings

🎜Using negative lookaround can ensure that the matching result will only have one 🎜string, that is, the matching result will not have multiple table-building statements🎜

漂亮男人 · Answer

Another idea: It should also be possible to use 宏

 :vim some.sql
 /field2
 qa{V}:w! >> wanted.sql
 nq
 99@a

The premise is that there must be no blank lines between the lines of each creation statement, and there must be blank lines at the beginning and end. See :h {
99@a 中的99 可以通过 %/field2//n Get

世界只因有你 · Answer

I wrote one casually and passed the test in sublime. For reference:

CREATE TABLE .*s.*`field2`[sS]*?ENGINE=InnoDB