Grab the 6 digit number only from the String

Learn Academy Feedback
1

Hi Helpers
I have an issue where bot needs to grab the 6 digit numbers from the string.
For example:
“The Jul 2019 statement for your stay is ending. View your more details on link.com. Your user id code is 123456, please fill up your details on our link. For more details please contact 02 13 15.”
From this string, the bot needs to grab “123456”, can Uipath grab it?

Your help will be highly respected.
Thank you

2

Hi @Kuenzang,
You can use very simple regex for this:

image
image988×187 10.9 KB

3 Likes
3

Hi @Pablito
Can you share me the workflow, I am new to Uipath.
Thank you

4

Instead of sharing final projects I would like to invite you to Academy and all 3 levels of trainings. Additionally regarding regex there are a lot of topics about this where you can find many examples:
https://forum.uipath.com/search?q=regex%20status%3Asolved

1 Like
5

Hi @Pablito
I have tried with your advice and got this result error. With this workflow.
err

opt
opt952×599 27.5 KB

6

@Kuenzang just use \d{6} only

1 Like
7

@Theepan
Same error
err1

8

@Kuenzang,

Below is your solution.
Please find your solution in the attached post, I have created a workflow and shared with @sayli

Mark my reply as a solution if it helps you.

Thanks and Regards,
@hacky

1 Like
9

give the text input

1 Like
10

@Theepan
I have given in the Input.

11

@hacky
Can you correct my script. please!
(upload://trpRzqR0EVzpnf5KxXRokFqxXkJ.xls) (30 KB)
Grab6digit.xaml (10.5 KB)

12

@hacky
test.xls (30 KB)

13

@Kuenzang,

Please find your solution, (check the test.xls file before and after the execution to observe).

test.xls (20 KB) Grab6digit.xaml (12.3 KB)

Also, kindly mark my answer as a solution if you found it useful.

Thanks and Regards,
@hacky

1 Like
14

@hacky
Thank you

1 Like
15

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