Hi All, I have a collection with multiple emailid's. i want to split the emailid's by @. Can someone help on this. Thanks.
Solved! Go to Solution.
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 ?
User | Count |
---|---|
156 | |
94 | |
82 | |
77 | |
58 |
User | Count |
---|---|
195 | |
175 | |
103 | |
96 | |
89 |