Using COUNT function to count number of addresses in a field


https://www.nevron.com/Forum/Topic10652.aspx
Print Topic | Close Window

By Steve Murray - 8 Years Ago
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....
By Nevron Support - 8 Years Ago
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.