# coding=utf8
# the above tag defines encoding for this document and is for Python 2.x compatibility
import re
regex = r"(?ms)(^NAME.*?)^\s+^\d"
test_str = ("SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 27 13:46:07 2016\n\n"
"Copyright (c) 1982, 2010, Oracle. All rights reserved.\n\n\n"
"Connected to:\n"
"Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\n"
"With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\n"
"Data Mining and Real Application Testing options\n\n\n"
"NAME\n"
"--------------------------------------------------------------------------------\n"
"Agent-Job Follow Up Missed Group D\n"
"Agent-Job Follow Up Missed Group E\n"
"Audit Archive\n"
"Day BGO - 705 and 705NA - A (2)\n"
"Day BGO - ERR Quebec - A\n"
"Dispatch Lunch Break Agent (Pre-Agent) - Group D\n"
"Helper Job Agent (Amend, Prevent, Lead) Group A\n"
"Incomplete Tasks Display Status Cleanup - Group A\n"
"Jeopardy Agent (Late EnRoute, OnSite, Complete) Group A\n"
"Jeopardy Agent (Late EnRoute, OnSite, Complete) Group B\n"
"Lunch Break Report Agent(Post-Agent) - Group A\n\n"
"NAME\n"
"--------------------------------------------------------------------------------\n"
"MST Validation - Group A\n"
"MST Validation - Group C\n"
"Unschedule INHS Tasks\n"
"Unschedule Jobs with Schedule Update Failure - Group E\n\n"
"15 rows selected.\n\n"
"Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\n"
"With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\n"
"Data Mining and Real Application Testing options")
matches = re.search(regex, test_str, re.MULTILINE | re.DOTALL)
if matches:
print ("Match was found at {start}-{end}: {match}".format(start = matches.start(), end = matches.end(), match = matches.group()))
for groupNum in range(0, len(matches.groups())):
groupNum = groupNum + 1
print ("Group {groupNum} found at {start}-{end}: {group}".format(groupNum = groupNum, start = matches.start(groupNum), end = matches.end(groupNum), group = matches.group(groupNum)))
# Note: for Python 2.7 compatibility, use ur"" to prefix the regex and u"" to prefix the test string and substitution.
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Python, please visit: https://docs.python.org/3/library/re.html