Rahul Anand
Rahul Anand

Reputation: 573

Extract text between two substrings using regular expression multiline in python

I want to extract text between two substring or phrases using python using regular expression.

Sample text:

NAME – Testing set ADDRESS – 1470 ROAD CONTACT NUMBER - +91-44578558774 E-MAIL – [email protected] 


PROFESSIONAL PROFILE 

A petroleum graduate with professional experience in workover operation & Surface Well Testing operation and implementation of procedures and best practices following knowledge management processes. Seeking a role in oil and gas industry to develop engineering and management skills and apply new ideas to real life industry problem. 


PROFESSIONAL EXPERIENCE 

RIG (JUN 2014 – SEPT 2015)  

Performed various workover operations in SRP and ESP wells developed in Ahmedabad (ONGC Project) & Durgapur (ESSAR Project). My responsibilities as Roustabout on Rig was to perform:  Make pipe connection & Operate Tongs while running in and Pull out of Sucker rod & Tubings.

CORE COMPETENCIES: 

1. Well versed with varioussoftware for well testing (Wireless software). 2. Good Knowledge of MS-EXCEL, MS-Word.

What will the regex be for extracting all the text between PROFESSIONAL PROFILE and CORE COMPETENCIES? I am not able to get the regex right.

Upvotes: 0

Views: 58

Answers (1)

MDR
MDR

Reputation: 2670

To continue from the comments...Try this as a demo...

import re

pattern = re.compile(r'PROFESSIONAL PROFILE([\s\S]+)CORE COMPETENCIES:')

data = '''
NAME – Testing set ADDRESS – 1470 ROAD CONTACT NUMBER - +91-44578558774 E-MAIL – [email protected] 


PROFESSIONAL PROFILE 

A petroleum graduate with professional experience in workover operation & Surface Well Testing operation and implementation of procedures and best practices following knowledge management processes. Seeking a role in oil and gas industry to develop engineering and management skills and apply new ideas to real life industry problem. 


PROFESSIONAL EXPERIENCE 

RIG (JUN 2014 – SEPT 2015)  

Performed various workover operations in SRP and ESP wells developed in Ahmedabad (ONGC Project) & Durgapur (ESSAR Project). My responsibilities as Roustabout on Rig was to perform:  Make pipe connection & Operate Tongs while running in and Pull out of Sucker rod & Tubings.

CORE COMPETENCIES: 

1. Well versed with varioussoftware for well testing (Wireless software). 2. Good Knowledge of MS-EXCEL, MS-Word.

'''

#print(pattern.search(data)[1])
#I think the  is tripping the code up so consider...
print(pattern.search(data)[1].encode('utf8'))

Outputs:

A petroleum graduate with professional experience in workover operation & Surface Well Testing operation and implementation of procedures and best practices following knowledge management processes. Seeking a role in oil and gas industry to develop engineering and management skills and apply new ideas to real life industry problem. 


PROFESSIONAL EXPERIENCE 

RIG (JUN 2014 – SEPT 2015)  

Performed various workover operations in SRP and ESP wells developed in Ahmedabad (ONGC Project) & Durgapur (ESSAR Project). My responsibilities as Roustabout on Rig was to perform:  Make pipe connection & Operate Tongs while running in and Pull out of Sucker rod & Tubings.

Upvotes: 1

Related Questions