Need help with extracting data using RegEx

Help Activities
, , ,
1

Hello Friends! I am new to UiPath and am in some help with a workflow I am creating.

Here is the scenario: I need to extract a certain piece of data from a website. (see below)The follow data i need is “12345678”.

“Your appointment request has been received but not yet processed.Load ID 12345678 has been assigned for your reference. Please review the Dock Commitments screen after sometime to see the assigned date and time or review your Carrier Schedule Report.”

image
image905×639 26.6 KB

I then save my data to a variable (ApptIDValue) and this is then added to a datarow within my data table i have. And what the issue is, i am not sure why the data table is showing 2; instead of 12345678. It was working before and now everytime the datatable in excel will have the number 2. Please help! :slight_smile:

image
image951×597 9.25 KB

2

Hi @kwhites5229

Welcome to forum

You can try regex like as below

image
image917×523 15.1 KB

Regards
Nived N
Happy Automation

3

Thank you ! :slight_smile:

does this look correct?

image
image957×597 13.6 KB

4

Try add the sample text in the Test Text section

See whether it is matching

@kwhites5229

(?<=Load ID )[0-9]+ this is the regex pattern

Regards
Nived N

Happy Automation

5

@kwhites5229 - If you unsure of what to select …I would suggest, do not click on “Configure Regular Expression”. Just put your Input and Pattern in the properties as shown below…

image
image1394×439 14.5 KB

6

unfortunately i can only test in live environment - but i will try this later when it runs and let you know thank you!

7

will try this option to thank you!!:slight_smile:

8

image002.jpg
image002.jpg1800×1091 129 KB

Hi guys I am getting this error when for when I tried to change the regex statement, so this error is happening after the regex.

Can you tell me what this means?

9

Hi guys, this is what i am getting… i am not sure what i am doing wrong here. Please advise if you can !

10
11

image

here is the error i am seeing

12

Hi @kwhites5229

Can u show value in Assign activitiy ?

13

and this is what the regex was -

image
image1029×643 15.2 KB

14

image
image1614×924 70.5 KB

15

Let’s say u had the output of regex matches in output_1 varaible

Then to get the value in string format use Assign activitiy as below

loanid= output_1.ElementAt(0).ToString

@kwhites5229

In ur case replace
LoadIDExtracted(0).ToString with
LoadIDExtracted.ElementAt(0).ToString

16

okay thanks so much i am going to try this now! :slight_smile:

1 Like
17

Please mark it as solution if it works for you @kwhites5229

18

image
image1629×864 54.1 KB

19

that is the error i received ^

20

Can u check LoadIDExtracted.Count?