How to write regex for extracting particular data which is above the word.?

Help Activities
,
1

Input:

Senior Audit Manager, Corporate Audit: xxx
ABC audit
January 26,2023

Table of contents

Output:

ABC audit
January 26,2023

i need to extract the 2 lines of data in the middle of the sentance.how can it be do it from regex?

2

Hi @yashashwini2322

Use the below regex expression
image

Hope it helps!!

3

Hi

System.Text.Regex.RegularExpressions.Match(“YourString”,“[A-Z]+\s[A-Z]*[a-z]+\s+[A-Z]+[a-z]+\s\d+,\d+”)).Value

Thank you

4

Hi @yashashwini2322

Try this

(?<=\n)(.*)(?=\n)

image
image733Ă—413 15.4 KB

5

Hi @yashashwini2322

if you need both as single exp

image
image943Ă—391 15.3 KB

If you need both with 2 expressions separately
Use for each

image
image984Ă—416 19.6 KB

Hope it helps!!

6

Hi @yashashwini2322 ,

We need to understand the data format and what are the constant words present in it that we can anchor too and get the required value.

Do we have data before the Sample data provided or is it the start of the data, do you require the values starting from the Second line ? Do you require the 2 lines above Table Of Contents ?

Understanding these requirements will help us give you the accurate suggestion.

7

@yashashwini2322

If you want it in a same line

image
image875Ă—403 17.3 KB

New line

image
image823Ă—417 17.7 KB

Hope it helps!!

8

Hi @yashashwini2322
Use the below regex expression

(?<=\:\s+[a-z]+\s+).*\s+.*(?=\s+)

image
image1413Ă—413 18.9 KB

Regards

9

Yeah…there will be number of lines but I want the data which is above the table of content

10

@yashashwini2322 ,

In that case, could you check with the below Regex Expression :

(.*\r?\n){2}(?=(\r?\n)*Table of contents)

image
image1064Ă—279 15.6 KB

11

What if i need to extract the next below lines(line numbers not constant) untill the next new line space.

12

@yashashwini2322 ,

With an Example data we can be more sure of what is that you are referring to.

13

Corporate

Feedline

Responsible executive:
Sidney dfg
Cioo, com bank
Tech & op

Audit abcdef

Repo

From the above I want to extract

Responsible executive:
Sidney dfg
Cioo, com bank
Tech & op

Untill the new line space I need to extract

14

@yashashwini2322 ,

Could you let us know what are the fixed keywords here that we can refer to for anchoring like we had Table of contents for the previous data sample.

15

Some times it’s
Responsible executive
Sometimes it’s
Unit head/Responsible executive
And sometimes it’s only
unit head

But the untill like is constant that means untill
Audit fieldwork duration
Need to extract

16

@yashashwini2322 ,

Considering the above points, the regex pattern is defined below :

(?<=(Responsible executive|Unit head:/Responsible executive|unit head):?\r?\n)[\S\s]+?\n(?=\n)

image
image774Ă—482 21 KB

Expression :

System.Text.RegularExpressions.Regex.Match(Strvariable,"(?<=(Responsible executive|Unit head:/Responsible executive|unit head):?\r?\n)[\S\s]+?\n(?=\n)",System.Text.RegularExpressions.RegexOptions.Multiline).Value

Debug Visuals :
image

Let us know if this is not the expected solution.

17

is input format always constant or it will change ?

18

16891592991795877293895166914886
168915929917958772938951669148861920Ă—1442 539 KB

Between Responsible executive and audit
Only 3 lines data is populating… I need the complete data which is between Responsible executive and audit fieldwork duration

19

@yashashwini2322 ,

In that case, change the Regex Expression to the below :

(?=(Responsible executive|Unit head:/Responsible executive|unit head):?)[\S\s]+?(?=Audit fieldwork)
20

Thank you so much…it works

1 Like