I have to multiple values from regex

Help Studio
, ,
1

I have to get multiple values from regex

image
image504×922 34.5 KB

output like:
54 93401
54 93401
54 93402
54 93402
54 93402
54 93402
54 93402
54 93402
54 93402
54 93402
54 93402
54 93402

thanks
shaik

2

Did you try some on-line regex tester?

Use .NET Regex Tester - Regex Storm for VB.NET regex testing
Alternative general regex testing site https://regex101.com/

Cheers

3

Hi @shaik.muktharvalli1

Can you please share the text file

Regards,

4

@shaik.muktharvalli1

you can try this

^\d{2} \d{5}

image
image904×801 50.2 KB

cheers

5

@shaik.muktharvalli1
you can use

\b54 \d{5}\b

image

Regards
Dheerandra Vishwakarma

6

Sample text file:

text.txt (100.5 KB)

thanks
shaik

7

numbers are dynamically changed

8

@shaik.muktharvalli1

I have used only number of numbers but not the actual numbers…if format is always 2 number space 5 numbers this would work…

if that is not case then provide more samples of different variations

cheers

9

it’s dynamically changing …

for example:
54 54765
34 5673
35 923
12 0485

10

@shaik.muktharvalli1

just use

\b54 \d{3,5}\b

it will be dynamic

image
Regards

11

@shaik.muktharvalli1

then you can use this

^\d* \d*

image
image959×771 55.6 KB

cheers

12

@shaik.muktharvalli1

Try this, it is working for all pages

^(\d+\s+\d+)(?![A-Z])

image
image1570×847 115 KB

Cheers!!

13

I have to get all number after MSISDN number ranges (s)

Can you send regular expression with variable

thanks
shaik

14

Hey @shaik.muktharvalli1

here the Screenshot for your references

And Attached the Xaml file below :upside_down_face:

Extract_Value_by_regex.zip (1.6 KB)

image
image1366×768 89.8 KB

regex :“\b54 \d{3,5}\b”

Cheers :upside_down_face: :pakistan:

15

@shaik.muktharvalli1

Is this not resolved with the change of regex?

Can you tell what the issue is if it still persists?

Cheers

16

Numbers are not constat it will dynamically change other transaction item.

Thanks
shaik

17

Hi @shaik.muktharvalli1
Use this regex given below :

regex :“\d{2} \d{3,5}\b”

excepted output :

Screenshot (9)
Screenshot (9)1366×768 87.8 KB

Cheers :upside_down_face: :pakistan:

18

Numbers are not constant, dynamically change next transaction item.

Ex:
54 674
2 345
987 3452

thanks
shaik

19

Hey @shaik.muktharvalli1
Use this regex given below :

regex :“\d{1,3} \d{3,5}\b”
image

Just replace this regex with previous regex and it will work

cheers :upside_down_face:

20

@shaik.muktharvalli1

Can you try the below

image
image829×1209 54.8 KB

Sequence17.xaml (15.0 KB)

Output:

MSISDN.xlsx (23.8 KB)

Regards,