Python - Regular expressions get numbers between p

Question

I need help creating a Regex to get numbers between parenthesis when my values are between word "PIC" and the "."

I got this records and need to be able to extract values between ()

PIC S9(02)V9(05).    I need this result "02 05"
PIC S9(04).          I need this result "04"
PIC S9(03).          I need this result "03"
PIC S9(03)V9(03).    I need this result "03 03" 
PIC S9(02)V9(03).    I need this result "02 03"
PIC S9(04).          I need this result "04"  
PIC S9(13)V9(03).    I need this result "13 03"

I have try the below but it doesnt work.

s = "PIC S9(02)V9(05)."
m = re.search(r"\([0-9]+([0-9]))\", s)
print m.group(1)

Answer 1

You can use re.findall() to find all numbers within the parenthesis:

>>> import re
>>> l = [
...     "PIC S9(02)V9(05).",
...     "PIC S9(04).",
...     "PIC S9(03).",
...     "PIC S9(03)V9(03).",
...     "PIC S9(02)V9(03).",
...     "PIC S9(04).",
...     "PIC S9(13)V9(03)."
... ]
>>> pattern = re.compile(r"\((\d+)\)")
>>> for item in l:
...     print(pattern.findall(item))
... 
['02', '05']
['04']
['03']
['03', '03']
['02', '03']
['04']
['13', '03']

where \( and \) would match the literal parenthesis (needed to be escaped with a backslash because of the special meaning they have). (\d+) is a capturing group that would match one or more digits.

Answer 2

Assumingly, your numbers are somewhat logically connected, you might therefore come up with the following code (including the explanation):

import re

string = """
PIC S9(02)V9(05).    I need this result "02 05"
PIC S9(04).          I need this result "04"
PIC S9(03).          I need this result "03"
PIC S9(03)V9(03).    I need this result "03 03" 
PIC S9(02)V9(03).    I need this result "02 03"
PIC S9(04).          I need this result "04"  
PIC S9(13)V9(03).    I need this result "13 03"
"""
rx = re.compile(
    r"""
    \((\d+)\)       # match digits in parentheses
    [^\n(]+         # match anything not a newline or another opening parenthesis
    (?:\((\d+)\))?  # eventually match another group of digits in parentheses
    """, re.VERBOSE)

for match in re.finditer(rx, string):
    if match.group(2):
        m = ' '.join([match.group(1),match.group(2)])
    else:
        m = match.group(1)
    print m

See a demo on regex101.com as well as on ideone.com.

Hint:

If you're having list items, simple go for \(\d+\).