How to get Ranges from Highlighted text using regular expression

Help Studio
, ,
1

How to get Ranges from Highlighted text

Out put like:
MSIDN_Start range MSIDN_End range
1000000 7999999
8200000 8999999
9600000 9999999
1000000 9999999
8000000 8099999
0000000 9999999

image
image910×580 16.4 KB

this is my first numbers getting regular expression:

“MSISDN number ranges (s).\n(\d.\n)+”)

I don’t know how to take ranges particularly, please help

thanks
shaik

Forum Engagement Daily Reports
2

Hi @shaik.muktharvalli1

Can you please share the text file.

Regards

3

text.txt (39.1 KB)

thank
shaik

4

Hi,

How about the following sample?

image
image1117×1620 46 KB

Sample
Sample20240604-2.zip (10.9 KB)

Please check Sheet1 and Sheet2 in result.xlsx because there seems 2 table in the text.

Regards,

1 Like
Forum Engagement Daily Reports
5

Hi @shaik.muktharvalli1

Check the below workflow:
Sequence39.xaml (13.9 KB)

Output:
image

Regards

6

@Yoichi in add data row activity…item.Groups not possible to me
how I can resolve it

Thanks
Shaik

7

HI,

Do you have any error? Can you share error message?

Regards,

8

@Yoichi Can you add ranges also same sheet
pleas help

thanks
shaik

9

H,

Do you mean it’s necessary to output 2 tables into 1 sheet as single table? If so, the following will work.

Sample20240604-2 (2).zip (10.9 KB)

Regards,

10

@Yoichi getting this error

WhatsApp Image 2024-06-04 at 15.52.32
WhatsApp Image 2024-06-04 at 15.52.321600×1200 247 KB

11

@Yoichi same sheet

thanks
shaik

12

Hi,

Can you try to modify Object to Match type at TypeArgument property of ForEach Asctivity?

Regards,

13

@Yoichi can you give only to get Highlighted row with regex expression with MSISDN number ranges

image
image1044×396 12.4 KB

thanks
shaik

14

THANKS @Parvathy Working fine

thanks
Shaik

15

Thanks @Yoichi working fine

Thanks
shaik

16

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