fork download
copy 
  1. import re
  2.  
  3. lst = ['SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9971, 18847, NULL), NULL, NULL)',
  4.        'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9971, 19188, NULL), NULL, NULL)',
  5.        'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9972, 18282, NULL), NULL, NULL)',
  6.        'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9977, 19201, NULL), NULL, NULL)',
  7.        'SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(9989, 18635, NULL), NULL, NULL)']
  8.  
  9. op = []
  10. for s in lst:
  11.     m = re.search(r"\bMDSYS\.SDO_POINT_TYPE\(([^()]+)\)", s)
  12.     if m:
  13.         op.append("({})".format(", ".join(re.findall(r"\d+", m.group(1)))))
  14.  
  15. print(op)
Success #stdin #stdout 0.03s 9532KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
['(9971, 18847)', '(9971, 19188)', '(9972, 18282)', '(9977, 19201)', '(9989, 18635)']
https://ideone.com/IuspyZ
language:
Python 3 (python  3.12)
created:
4 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!