Get the values in Get Text


#1

I have this Get Text Value which contains an ID, Email, etc…

I would like to get only the Application ID to be reset (zxzxzxzx) and Email (sample@email.com)

i’m having trouble with the Split function. PLEASE Help! Thank you.

image


#2

Hi @criskitz,

Can you post the data as text instead of image to test the solution.

Regards
Balamurugan


#3

sure here it is:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX -Password Reset Request

Application Login ID to be reset (not SSN): zxzxzxzx
AD ID: xxxxxxxx
Name: First, Last
Email: sample@email.com
Access To Email: No
Phone: 80800000
Manager Phone: 80800000
Manager Email: sample@email.com
Other:


#4

Hi @criskitz,

You can use positive lookbehind and ahead to capture the group. For example you can use this regular expression to capture that group:

(?<=AD\sID:\s*)\w*(?=\nName)

And for email it will be:

(?<=Email:\s*)\w*(?=\sAccess)

Your code should look like:

Matches(theWholeText, “(?<=AD\sID:\s*)\w*(?=\nName)”)

Alternatively you can split by new line so one of those iterations will have “AD ID: xxxxxxxx” and the use replace and replace "AD ID: " with “”.


#5

Hi @criskitz,
Here I have attached the source to get the application id and email.

File : AppString.zip (2.0 KB)

image

Regards
Balamurugan


#6

You are awesome!!! working great but i do not understand the vb.net :slight_smile:


#7

Hi @criskitz,
Thank you.

For the vb.net I don’t know what I have to say. It is programming language.you can learn it . When ever you have the chance. But don’t worry. It is not must. The Uipath people and community people are always with you what ever the problem you have.

Regards
Balamurugan