How to get postal code and email for below regex

Help Activities
, ,
1

Hi

How extract postal code value from regex

Example below is the txt

Postal Code

941332

Customer Service Representative (Optional)

output:
941332

  1. extract email from below test using regex

Email

jac.tiongsothtr@ucgfhng.edumailto:jac.tiongsothtr@ucgfhng.edu

Job Title (Optional)

output:
jac.tiongsothtr@ucgfhng.edu

please provide the solution

Thanks
Likitha

2

Hi @vinjam_likitha

(?<=Postal Code[\s\S]*)\d+

This image shows a regular expression (regex) pattern designed to capture a postal code followed by digits, with an example text highlighting a match for the given postal code "941332". (Captioned by AI)
This image shows a regular expression (regex) pattern designed to capture a postal code followed by digits, with an example text highlighting a match for the given postal code "941332". (Captioned by AI)1432×501 21.7 KB

(?<=mailto:).*

A regular expression is used to match a specific email address pattern, which successfully identifies the email "jac.tiongsothtr@ucgfhng.edu" in the provided text. (Captioned by AI)
A regular expression is used to match a specific email address pattern, which successfully identifies the email "jac.tiongsothtr@ucgfhng.edu" in the provided text. (Captioned by AI)1434×472 21.9 KB

Regards,

3

Hi @vinjam_likitha

1. Regular Expression to extract Postal Code:
Regex Expression: (?<=Postal Code\s*)\d+
Assign Syntax: System.Text.RegularExpressions.Regex.Match(Input,"(?<=Postal Code\s*)\d+").Value.Trim()

The image shows the result of testing a regular expression to match a postal code, successfully finding the postal code "94132" in the provided text. (Captioned by AI)
The image shows the result of testing a regular expression to match a postal code, successfully finding the postal code "94132" in the provided text. (Captioned by AI)1430×605 21.9 KB

This image shows a sequence in an automation workflow where an input string "Postal Code" is processed via regex, and the output "941332" is displayed in a message box. (Captioned by AI)
This image shows a sequence in an automation workflow where an input string "Postal Code" is processed via regex, and the output "941332" is displayed in a message box. (Captioned by AI)1016×621 25.8 KB

2. Regular Expression to extract Mail ID:
Regex Expression: [a-z.@]+(?=mailto)
Assign Syntax: System.Text.RegularExpressions.Regex.Match(Input,"[a-z.@]+(?=mailto)").Value.Trim()

The image shows a regex test tool identifying an email address based on a specific regex pattern provided in the input field. (Captioned by AI)
The image shows a regex test tool identifying an email address based on a specific regex pattern provided in the input field. (Captioned by AI)1437×490 24.7 KB

The image shows a UiPath sequence with activities to assign an email address to the 'Input' variable, extract it with a regular expression into the 'Output' variable, and display it in a message box. (Captioned by AI)
The image shows a UiPath sequence with activities to assign an email address to the 'Input' variable, extract it with a regular expression into the 'Output' variable, and display it in a message box. (Captioned by AI)1021×711 28.1 KB

Regards

4

Please try this:

postal_code_pattern = r’(?<=Postal Code\s+)(\d+)’

email_pattern = r’(?<=Email\s+)([\w.-]+@[\w.-]+(?:.[a-z]{2,}))’