Profile Picture

Using COUNT function to count number of addresses in a field

Posted By Steve Murray Last Year

Using COUNT function to count number of addresses in a field

Author
Message
Steve Murray
Question Posted Last Year
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 11 Months Ago
Posts: 17, Visits: 79
I am using a sharepoint list which has a concatenated list of email addresses (up to 100) inside Fields!Email_Addresses field.
Can I use the COUNT function to count the number of occurrences of "@" within the Fields!Email_Addresses field. 
This is one record with many email addresses inside the field.
If possible, give me the correct formula?
Thanks....


Tags
Nevron Support Team
This post has been flagged as an answer
Posted Last Year
View Quick Profile
Supreme Being

Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)

Group: Moderators
Last Active: 3 days ago @ 8:33 AM
Posts: 2,593, Visits: 2,279
Hi Steve,

As far as we understand you have records like:
name1@gmail.com; name2@yahoo.com -
so for example for this rrecord you want to get the value of 2.

Unfortunately you cannot do that with an expression, but you can achieve this with custom code.



Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic