Not able to Split properly

Help Studio
, , ,
#21

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

1 Like
#22

Thankyou so much for the response

image
image858×177 5.62 KB

Showing some identifier expected.

1 Like
#23

ok sure.

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

#24

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

#25

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

But still i m facing the issue

image
image1600×900 105 KB

1 Like
#26

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

#27

@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
#28

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

#29

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

2 Likes
#30

I got my mistake
I have modified the comments
@Snehamayi_Sneha

#31

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

#32

@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

#33

Fine
Here you go
BlankProcess16.zip (9.3 KB)

Cheers @Snehamayi_Sneha

1 Like
#34

Hey …Super it works perfectly now… :slight_smile:

Thanks alot for the help

1 Like
#35

Cheers @Snehamayi_Sneha

1 Like
#36

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