How to extract every string in between different Delimeters

Help Activities
, ,
1

I have a string like this “mich.bommattrto@abc.com; Tom.Szski@abc.com; Chaterd.Andrs@abc.com” and I want to extract mich_Tom_Chaterd from this string.

This string contains 3 emails but there are strings that contains 1,2 or more than 3 emails.I want a generic solution

String Expected Results
mich.bommattrto@abc.com; Tom.Szski@abc.com; Chaterd.Andrs@abc.com mich_Tom_Chaterd
David.Docker@abc.com; cary.crise@abc.com David_cary
richard.kossik@abc.com;tim.mawell@abc.com;Natolie.Cryt@abc.com;cary.crise@abc.com richard_tim_Natolie_cary
Ricard.Allyytt@abc.com Ricard
2

@faiqaqureshi90
have a look here:

grafik
grafik733×186 4.98 KB 

String.Join("_",(Regex.Matches(strText,"(\.|\w)*?(?=\@)").Cast(Of Match).Select(Function (x) x.toString.Split("."c)(0))))

Ensure following:
grafik

Challenging it with missing dots:
grafik

3

Its Working
Can you please explain this?

4

image
image1170×767 30.5 KB

Assign-0:
Str_Mails = “mich.bommattrto@abc.com; Tom.Szski@abc.com; Chaterd.Andrs@abc.com”
Assign-1:
Str_Test = Str_Test + Split(Mail.Trim,“.”)(0) + “_”
Assign-2:
Str_Test = Str_Test.Substring(0,Str_Test.Length-1)

5

Regex - Regex101.com
grafik

With regex we do take all strings before the @ character
From all matches we do a split on the dot and take the first item
With String.Join we do surround the items with a “_”

1 Like
6

Thanks Alot
It really helped

7

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