Regex with multiple underscore

Help StudioX
1

Hello,

I am trying to extract the email id.

Text:
2dbccf5bc0de_327050.0670_sun_engineer@sun.com
4bb1-a91d-23bd336d7b1e_362833.0120_Steffi.Gill@kjhk-one.de

My expression to split is:
Mystring.ToString.Split("_"c)(1).ToString

It works for the second one but not for the first one as I only get sun as an output.

I tried Regex : “[a-zA-Z0-9-.]+@[a-zA-Z-]+.[a-z]{2,}”
but I get only “engineer@sun.com”.

How can it work for both the expression.

2

Hi @parnalmahavir.patni

Try this

(?<=\d+_).*

A regular expression search in JavaScript is shown identifying email addresses from a string of text. (Captioned by AI)
A regular expression search in JavaScript is shown identifying email addresses from a string of text. (Captioned by AI)1351×490 21 KB

Regards,

3

Hi @parnalmahavir.patni

(?<=\_)[A-Za-z]+.*

This image shows a text editor with a regular expression search, highlighting two email addresses: "sun_engineer@sun.com" and "Steffi.Gill@kjhk-one.de". (Captioned by AI)
This image shows a text editor with a regular expression search, highlighting two email addresses: "sun_engineer@sun.com" and "Steffi.Gill@kjhk-one.de". (Captioned by AI)1375×425 18.6 KB

4

@parnalmahavir.patni

System.Text.RegularExpressions.Regex.Match(Input,"(?<=\d+_).*").Value

The image depicts a workflow in UiPath where an email address is extracted from an input string using a regular expression and displayed in a message box. (Captioned by AI)
The image depicts a workflow in UiPath where an email address is extracted from an input string using a regular expression and displayed in a message box. (Captioned by AI)772×357 16.1 KB

The image shows a flow diagram with an initial message box displaying an email address, followed by steps to assign an input string, apply a regular expression to extract an email, and output the extracted email in another message box. (Captioned by AI)
The image shows a flow diagram with an initial message box displaying an email address, followed by steps to assign an input string, apply a regular expression to extract an email, and output the extracted email in another message box. (Captioned by AI)769×372 16.7 KB

Regards,

5

It shows error
Assign: Invalid pattern ‘(?<=_)[A-Za-z]+.*’ at offset 6. Unrecognized escape sequence \_.

7

Hi @parnalmahavir.patni

Can you try the below regular expression:

The image shows a regular expression used to find email addresses within a text, with the regex pattern highlighted and two matching email addresses identified in the text below. (Captioned by AI)
The image shows a regular expression used to find email addresses within a text, with the regex pattern highlighted and two matching email addresses identified in the text below. (Captioned by AI)1428×492 25.1 KB

System.Text.RegularExpressions.Regex.Match(Input,"(?<=\d+_)[a-zA-Z0-9-._]+@[a-zA-Z-]+.[a-z]{2,}").Value.Trim()

The image shows a code debugging window with regular expression matches for two email addresses extracted from strings. (Captioned by AI)

Regards

8

@parnalmahavir.patni

How about the following?

((?<=\d{4,}_)[A-Za-z]+.*)

The image shows a regex search results highlighting email addresses and file paths from a text editor interface. (Captioned by AI)
The image shows a regex search results highlighting email addresses and file paths from a text editor interface. (Captioned by AI)1435×475 57.8 KB

Regards,

1 Like
9

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