Split emailid's from collection values

[BKGOUD]

Hi All, I have a collection with multiple emailid's. i want to split the emailid's by @. Can someone help on this. Thanks.

[gabibalaban]

Hi @BKGOUD ,

You can split in two columns the email addresses using something like this:

AddColumns(YourCollection,"PartBefore@",Left(emailid,Find("@",emailid)-1),"PartAfter@",Right(emailid,Len(emailid)-Find("@",emailid)))

I add to your collection two columns one with the partbefore@ and one with the partafter@.

Is this what you want to achieve ? 

[BKGOUD]

Hi @gabibalaban ,

Thanks for helping me. I used your code but it gives the error as expected text.

[gabibalaban · Accepted solution]

@BKGOUD  Please give me a screenshot with the error !