Nevron Forum

Using COUNT function to count number of addresses in a field

https://www.nevron.com/Forum/Topic10652.aspx

By Steve Murray - Friday, April 1, 2016

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 - Tuesday, April 5, 2016

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.