+ Start a Discussion
Shephali SwarnkarShephali Swarnkar 

how to count description field in contact object

Hi All,
        I actually want to use count() on description object so that i can count the number of records in description field of contact object but its not working as it does not support for long text area data type.so i tried it using "Field Updates" in workflow rule. 
I have a custom field Notes__c(Data type:text area) 
formula given is: LEFT (Description, FIND(" ", Description))
but it is not working.Please help so that i can count on description field.

Thanks
 
Shashikant SharmaShashikant Sharma
What is example value for description field and are you looking to calculate number of string values separated by blank space. Please answer these as that is required in order to help on this question.

Thanks
Shephali SwarnkarShephali Swarnkar
Hi Shashikant,
   Thanks for reply.
  Actually i want to count the number of records in description field(my actual requirement). but somehow Count() is not supporting for "long text Area" data type. Thats why m looking for another way to achieve it.
   here i want to filter it for null records also
list<contact> desc=[select Description from contact where owner.name='ABC' and description!='NULL'];
       here too m geeting error:
Compile Error: field 'description' can not be filtered in query call at line 17...
Question:how to count the number of records for perticular user where description field should not be 'NULL'