Using COUNT function to count number of addresses in a field
Print Topic | Close Window

By Steve Murray - 6 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?
By Nevron Support - 6 Years Ago
Hi Steve,

As far as we understand you have records like:; -
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.