UltraEdit, UltraCompare, UEStudio forums

This could be an example of SELECT statement which I would like to identify inside a text file, looking for SELECT's which contain the word 'A' inside the FROM clause and the word 'A1' or 'A2' in the WHERE clause. SELECT A.A1 AS FIELD1, B.B1 AS FIELD2 --This is a one-line comment FROM TABLE_A A, TAB...

Give us a small example, how one of the files with SELECT looks like and explain which criteria you want for the find expression. They are PL/SQL code files (packages, functions and no-named blocks). The criteria is simple, I want to find out what files have SELECT statements with a concrete table ...

Hi, I'm trying to find in a folder (find in files) all the text documents containing a SELECT statement wich contain concrete fields in WHERE clause, but the more I try, the more I fail. The regex i tried last time, after some hours of thinking and searching very carefully was this: select[\s\r\n\w\...