Extract string between two box

Help Studio
, ,
1

Sample text - ☐9:00 A.M. – 10:00 A.M. ☐10:00 A.M. – 11:00 A.M. ☒11:00 A.M. – 12:00 P.M. ☐12:00 P.M. – 1:00 P.M.

Expected - 11:00 A.M. – 12:00 P.M.
Note i want to extract time span next to ☒ this sign

@supermanPunch @Sudharsan_Ka @Anil_G

3

Hi @pravin_bindage ,

Maybe you could try with the below regex :

(?<=☒).*(?=☐)

image

Expression :

Regex.Match(yourString,"(?<=☒).*(?=☐)").Value.Trim
2 Likes
4

grafik
grafik1005×228 12.6 KB

And also refer to groups:
grafik

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

whenever we can rely on

☒

then we can anchor as mentioned above e.g. by Arpan

1 Like
5

I m reading word file & extracting text from that string . I get index was outside bounds of array @supermanPunch @ppr
Patient Registration Form_Sample1.docx (4.8 MB)

6

@pravin_bindage ,

Let us know if this error happens in reading the file and not when performing the regex operation as mentioned above. I do not think we would get that Error from the above Regex Match operation.

Let us know which activity or step gives out the error and maybe we can move that discussion to a different topic.

1 Like
7

I m using this synntax to extract First name -
System.Text.RegularExpressions.Regex.Split(str,“\n”)(9)

8

I get this error for assign activity

9

image
image874×1005 44.7 KB

10

@pravin_bindage ,

As suggested, It looks like a different requirement, We can help you out on this in a Separate Topic.

Mention your requirements (Capturing First Name), Input and Expected Output, So we can help you in that specific topic.

1 Like
11

Created new post

12

Results like this -
11:00 A.M. – 12:00 P.M. ☐12:00 P.M. – 1:00 P.M.☐1:00 P.M. – 2:00 P.M. ☐2:00 P.M. – 3:00 P.M. ☒3:00 P.M. – 4:00 P.M. ☐4:00 P.M. – 5:00 P.M.
I want only - 11:00 A.M. – 12:00 P.M.

13

@pravin_bindage ,

I believe the Output for this data should be 3.00 PM. - 4:00 P.M. as the ☒ is present before 3 PM
image

14

What if In case of “☒” this sign is at last time span

☐9:00 A.M. – 10:00 A.M. ☐10:00 A.M. – 11:00 A.M. ☐11:00 A.M. – 12:00 P.M. ☐12:00 P.M. – 1:00 P.M.

☐1:00 P.M. – 2:00 P.M. ☐2:00 P.M. – 3:00 P.M. ☐3:00 P.M. – 4:00 P.M. ☐4:00 P.M. – 5:00 P.M. ☒5:00 P.M. – 6:00 P.M.

15

Hi @pravin_bindage ,

It will work for both the conditions as per below screenshot,

image
image1366×443 52.2 KB

Regular Expression:
(?<=☒)\d{1,2}:\d{1,2}\s+[A-z.]+\s+.\s+\d{1,2}:\d{1,2}\s+[A-z.]+

Hope this helps :smiley:

1 Like
16

@pravin_bindage ,

Yes. The regex expression provided earlier doesn’t get the data if there isn’t an Empty Box at the end as well.

So you could go ahead with the suggestion provided by @Manish540 in the above post.

Or Maybe with the below more specific regex expression :

(?<=☒)\d+:\d+\s(A|P)\.M\.\s.\s\d+:\d+\s(A|P)\.M\.

image

1 Like