Counting values in a single field

Question

I need to count the number of apartment units entered in a field we have called Unit #,There is always a comma to separate them, but I cannot q​uite seem to figure out how to use the count function.I have a field called # of units that I would like to use the formula in.
Any help is appreciated.Brandy​------------------------------Brandy Nunes------------------------------

MarkShnierYou · Answer

try thisvar text value = [my comma separated text field];Count(Trim(Part($value,1,";"))<>"",Trim(Part($value,2,";"))<>"",Trim(Part($value,3,";"))<>"",Trim(Part($value,4,";"))<>"",Trim(Part($value,5,";"))<>"",Trim(Part($value,6,";"))<>"",Trim(Part($value,7,";"))<>"",Trim(Part($value,8,";"))<>"",Trim(Part($value,9,";"))<>"",Trim(Part($value,10,";"))<>"",Trim(Part($value,11,";"))<>"",Trim(Part($value,12,";"))<>"",Trim(Part($value,13,";"))<>"",Trim(Part($value,14,";"))<>"",Trim(Part($value,15,";"))<>"",Trim(Part($value,16,";"))<>"",Trim(Part($value,17,";"))<>"",Trim(Part($value,18,";"))<>"",Trim(Part($value,19,";"))<>"",Trim(Part($value,20,";"))<>"",Trim(Part($value,21,";"))<>"",Trim(Part($value,22,";"))<>"",Trim(Part($value,23,";"))<>"",Trim(Part($value,24,";"))<>"",Trim(Part($value,25,";"))<>"")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community