How to extract a part of the string in python?

Question

I have the following list:

lst = ['SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9971, 18847, NULL), NULL, NULL)', 
'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9971, 19188, NULL), NULL, NULL)',
'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9972, 18282, NULL), NULL, NULL)',
'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9977, 19201, NULL), NULL, NULL)',
'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9989, 18635, NULL), NULL, NULL)']

I would like to extract only the string that contains the number in brackets after MDSYS.SDO_POINT_TYPE. How do I do that?

What I tried so far?

op=[]
for i in lst:
    x = (i[46:56])
    y = str('('+x+')')
    op.append(y)

But, the numbers are not always in position 46-56, how do I optimize that?

Desired output:

['(9971, 1884)',
 '(9971, 1918)',
 '(9972, 1828)',
 '(9977, 1920)',
 '(9989, 1863)']

not_speshal · Accepted Answer · 2021-06-09 15:08:45Z

2

You can use regular expressions:

import re
>>> [re.findall("MDSYS.SDO_POINT_TYPE\((\d+, \d+)", s)[0] for s in lst]
['9971, 18847', '9971, 19188', '9972, 18282', '9977, 19201', '9989, 18635']

answered Jun 9, 2021 at 15:08

not_speshal

23.2k2 gold badges18 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

alani Over a year ago

Indeed, though if the desired output includes parentheses then your output will need to be post-processed. Fairly trivially done with [f'({pair})' for pair in list_of_pairs] or whatever.

gaurav · Accepted Answer · 2021-06-09 15:13:28Z

1

I am using simply split to break it in list and combining again with string

lst = ['SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9971, 18847, NULL), NULL, NULL)', 
    'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9971, 19188, NULL), NULL, NULL)',
    'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9972, 18282, NULL), NULL, NULL)',
    'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9977, 19201, NULL), NULL, NULL)',
    'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9989, 18635, NULL), NULL, NULL)']

new_lst = []
for st in lst:
  name,points = st.split('MDSYS.SDO_POINT_TYPE(')
  f_num, s_num, *rest_ = points.split(',')
  new_lst.append(f"({f_num},{s_num})")

print(new_lst)

answered Jun 9, 2021 at 15:13

gaurav

1,3371 gold badge14 silver badges25 bronze badges

Comments

The fourth bird · Accepted Answer · 2021-06-09 15:24:52Z

If the numbers between the parenthesis and the NULL can be at different positions, you can use a pattern to first get the values between parenthesis in a capture group.

Then you can find the digits in the group 1 value.

\bMDSYS\.SDO_POINT_TYPE\(([^()]+)\)

\bMDSYS\.SDO_POINT_TYPE\( match MDSYS\.SDO_POINT_TYPE(
([^()]+) Capture all between parenthesis in group 1
\) Match closing )

See a Python demo ad a Regex demo

Note that in desired output the last digit is missing for the second value.

import re

lst = ['SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9971, 18847, NULL), NULL, NULL)',
       'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9971, 19188, NULL), NULL, NULL)',
       'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9972, 18282, NULL), NULL, NULL)',
       'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9977, 19201, NULL), NULL, NULL)',
       'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9989, 18635, NULL), NULL, NULL)']

op = []
for s in lst:
    m = re.search(r"\bMDSYS\.SDO_POINT_TYPE\(([^()]+)\)", s)
    if m:
        op.append("({})".format(", ".join(re.findall(r"\d+", m.group(1)))))

print(op)

Output

['(9971, 18847)', '(9971, 19188)', '(9972, 18282)', '(9977, 19201)', '(9989, 18635)']

Collectives™ on Stack Overflow

How to extract a part of the string in python?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related