I have to matches below highlighted area with Regex

Help Studio
, ,
1

I have to matches below highlighted are From Network Nodes to MSRN Number with regex

The image shows a regular expression pattern highlighted at the top and a document excerpt below it, with a specific section circled that details MNO and MSRN number ranges. (Captioned by AI)
The image shows a regular expression pattern highlighted at the top and a document excerpt below it, with a specific section circled that details MNO and MSRN number ranges. (Captioned by AI)938×348 40.6 KB

Thanks
Shaik

2

any one help please :pray:

Thanks
Shaik

3

Hello @shaik.muktharvalli1

You can use the below Regular expression to extract the required data based on the MSRN Number keyword,

[\d\sA-Z]+(?=\s+MSRN Number)

The image shows a regular expression tool highlighting a specifc match in a sample text, which displays MSRN number ranges along with other related details. (Captioned by AI)
The image shows a regular expression tool highlighting a specifc match in a sample text, which displays MSRN number ranges along with other related details. (Captioned by AI)1375×433 34.2 KB

Note: Use Trim to remove the unwanted spaces.

Hope it helps!!

4

@mkankatala But I need to get only from Network Nodes to MSRN Number

Thanks
shaik

5

Okay I am bit confused, could you share the input in text and expected output again… @shaik.muktharvalli1

6

input file:

Read_Pdf.txt (25.9 KB)

A list of network and MSN number ranges with specific details, where some segments are circled for emphasis. (Captioned by AI)
A list of network and MSN number ranges with specific details, where some segments are circled for emphasis. (Captioned by AI)660×161 6.43 KB

I need to get only Highlighted roundup area

thanks
shaik

7

Above Regular expression is work as you expected. Have you tried above expression… @shaik.muktharvalli1

Check the below image for better understanding,

This image shows a text editing tool highlighting multiple lines of numeric codes, possibly related to MSRN number ranges, with a regular expression used for matching specific patterns. (Captioned by AI)
This image shows a text editing tool highlighting multiple lines of numeric codes, possibly related to MSRN number ranges, with a regular expression used for matching specific patterns. (Captioned by AI)1050×747 68 KB

8

can you extract only from Network nodes to MSRN Number please

Thanks
Shaik

9

@mkankatala some time MSRN Number text not found then what happen

can you take Initial extract text from Network Nodes please

please share regex

Thanks
Shaik

10

which text is static in the input text… @shaik.muktharvalli1

11

@mkankatala below text is statis for Network nodes

Network Nodes Global Title Number Ranges
CC NDC SN Range Start SN Range Stop Prim. Intl. DPC Sec. Intl. DPC Network Owner Leas. Details

Thanks
Shaik

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.