Using COUNT function to count number of addresses in a field

Author	Message
Steve Murray	Steve Murray posted 9 Years Ago Topic Details
Group: Forum Members 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 ARRAY COUNT
	Reply Like 0
Nevron Support	Nevron Support posted 9 Years Ago ANSWER Post Details
Group: Administrators Posts: 3.1K, Visits: 4.1K	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
	Reply Like 0