Not able to Split properly

Help Studio
, , ,
#1

Hi Team ,

I am trying to split the below format.I need only the email address as"snehamayi.senapati@tx.com".
Please help me out
Eg:
firstname lastname emailaddress starts here below is the string i have
Snehamayi Senapatisnehamayi.senapati@tx.com

Thanks,
Sneha

#2

did you try using regex??
to extract only mail ID?
Cheers
@Snehamayi_Sneha

#3

image

have a look at this it’s extracting the required field!
([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,6})

cheers
@Snehamayi_Sneha

1 Like
#4

Thanks for your quick response.

The above extract is giving this **[Senapatisnehamayi.senapati@tx.com]

But i need as this snehamayi.senapati@tx.com .

I have list of strings added to excel but i need only the email ids

Snehamayi Senapatisnehamayi.senapati@fujitsu.com
Snegha Misnegha.mi@tx.com → snegha.mi@tx.com
Snehal KotSnehal.Kot@tx.com → Snehal.Kot@tx.com

I need to make it dynamic after lastname it needs to split the emailid.

Thanks

#5

Hi,
Use invoke code activity write code below

Dim list As List(Of String)=(From a In Split(MailAddresses," “)
Where Regex.IsMatch(a,”^([\w.-]+)@([\w-]+)((.(\w){2,3})+)$")
Select a).ToList

where MailAddresses is string variable having space separated mail ids , here its filter out all invalid mail ids and keep only valid mail ids

1 Like
#6

@Snehamayi_Sneha Check this :
RegexEmail.xaml (5.9 KB)

#7

Thanks for your quick response.

The above extract is giving this **[Senapatisnehamayi.senapati@tx.com]

But i need as this snehamayi.senapati@tx.com

#8

@Snehamayi_Sneha Have you Changed the Input? Does it come in the message box in that way?

#9

Fine if the input is stored in a variable named strinput
Then use a assign activity like this
stroutput = System.Text.RegularExpressions.Regex.Match(strinput.ToString,”\s.+(?=@).+(?<=.com)”)

It’s working

image
image828×407 99.6 KB

Cheers @Snehamayi_Sneha

#10

yes i got the alert as image

#11

@Snehamayi_Sneha Isn’t that the format you wanted ?:sweat_smile:

#12

i need only snehamayi.senapati@tx.com

#13

But i need only snehamayi.senapati@tx.com

#14

Can I have few more examples
@Snehamayi_Sneha

#15

Snegha Misnegha.mi@tx.com
→ snegha.mi@tx.com (i need this from above string)
Snehal KotSnehal.Kot@tx.com
→ Snehal.Kot@tx.com (i need this from above string)

1 Like
#16

image Main.xaml (4.2 KB)
check this sample and let me know
store your FirstName in variable that would be easy!
cheers
@Snehamayi_Sneha

1 Like
#17

@Snehamayi_Sneha Check this and Confirm with all different type of Email Strings that you have :sweat_smile: Dont know if it works for all cases
RegexEmail.xaml (6.9 KB)

1 Like
#18

Thanks for the response some what it works but some cases it is failing.

#19

Thanks for the response …

But the code is simple may be it will not work for dynamic strings.

#20

Fine this expression would help you in this
If stored in strinput
Then in a assign activity

stroutput = system.Text.RegularExpressions.Regex.Replace(strinput.ToString,".+(?=[.]\w.+@)",Split(strinput," ")(0).ToString)

Cheers @Snehamayi_Sneha