Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
r"
^(VIEW\s+(\w+))(.*(?:\n(?!SELECT|VIEW|FROM).*)*)\nSELECT\s+(.*(?:\n(?!SELECT|VIEW|FROM).*)*)\nFROM\s+(\w+(?:\s+\w+));
"
gmi
Input 1
VIEW Company_Person_Sd IS Prompt = 'Company' Company.Prompt = 'Company ID' SELECT company_id company_id, emp_no emp_no, Get_Person(company_id, emp_no) person_id, cp.rowid objid, to_char(cp.rowversion) objversion, rowkey objkey FROM companies cp; VIEW Company_Person_Sd IS Prompt = 'Company' Company.Prompt = 'Company ID' SELECT company_id company_id, emp_no emp_no, Get_Person(company_id, emp_no) person_id, cp.rowid objid, to_char(cp.rowversion) objversion, rowkey objkey FROM companies cp;