Profile Picture

Using COUNT function to count number of addresses in a field

Posted By Steve Murray 8 Years Ago

Using COUNT function to count number of addresses in a field

Author
Message
Steve Murray
Question Posted 8 Years Ago
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: 7 Years 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
This post has been flagged as an answer
Posted 8 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: Last Week
Posts: 3,054, Visits: 4,009
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