I am trying to create a COUNT function that will search out a word in the table [WORKORDER DESCRIPTION]. I am trying to pull out the word 'Ants' and place them in a bar chart. I also don't know if the word will be case sensitive.
If you want to detect string 'ants', not case-sensitive, but no count, use
wildmatch([WORKORDER DESCRIPTION], '*ants*')
It will return 0 if there is no match, and a positive number if there is at least one.
If you really need count, use :
substringcount(upper([WORKORDER DESCRIPTION], 'ANTS'))
Retrieving data ...