Not able to Split properly

@Snehamayi_Sneha Can you show an example String for the Case it is failing?

1 Like

Thankyou so much for the response

Showing some identifier expected.

1 Like

ok sure.

Snehal KotSnehal.Kot@in.taxozz.com → i m getting Snehal.Kot@in.taxozz (.com is missing here)

Aah
I missed the double quotes
Typo mistake buddy
stroutput = system.Text.RegularExpressions.Regex.Replace(strinput.ToString,".+(?=[.]\w.+@)",Split(strinput," ")(0).ToString)

Cheers @Snehamayi_Sneha

Thanksyou for the quick response…Are you getting the output correctly?

But still i m facing the issue

1 Like

Oh my god
how bad I was
This is the one (May be another method)
stroutput = Strinput.ToString.Replace(System.Text.RegularExpressions.Regex.Match(strinput.ToString,“.+(?=[.]\w.+@)”),Split(“ “,strinput.ToString)(0).ToString.Trim).ToString

Cheers @Snehamayi_Sneha

@Snehamayi_Sneha Can you check this, This Should probably work for all the Kinds of Email Strings :sweat_smile: :
RegexEmail.xaml (7.3 KB)

1 Like

Sorry again issue. could you try once and send the xaml file please.

Ya this worked thanks for the quick response.I am trying with different example will let you know soon…
Thankyou

2 Likes

I got my mistake
I have modified the comments
@Snehamayi_Sneha

No again issue if it worked for you plz give me the xaml file.

@Snehamayi_Sneha

IT LOOKS REALLY EASY…

AS per I saw in this post so far, I have used some sample email IDs that you provided here.

Instead of using the regex approach, I have used the simple string manipulations in to extract the required output.

Kindly find the below xaml file to check if it satisfies your requirements.
@snehamayi_Sneha_Solution.xaml (11.2 KB)

I have used three samples as a static values in the variables. But if you want I can have a excel file with the column of input strings and corresponding output column. And run the for loop for your simplicity.

Also mark this as solution if it helps.

Thanks and Regards,
@hacky

Fine
Here you go
BlankProcess16.zip (9.3 KB)

Cheers @Snehamayi_Sneha

1 Like

Hey …Super it works perfectly now… :slight_smile:

Thanks alot for the help

1 Like

Cheers @Snehamayi_Sneha

1 Like

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