I need to find how many times a particular word appears in a particular field.
How can i do that?
for an instance - (jan,mar,jan,feb,aug,sep,jan)
how many "Jan"'s in the above field?
Printable View
I need to find how many times a particular word appears in a particular field.
How can i do that?
for an instance - (jan,mar,jan,feb,aug,sep,jan)
how many "Jan"'s in the above field?
You could use Split to get each element into an array and then loop through them.
Put the field in the detail secton and either use the sum tab and use the DistinctCount option or write a a formula
"DistinctCount (your field)"
It looks like Crystal Fire and I have understood your question differently.
Do you have a field which contains the string "(jan,mar,jan,feb,aug,sep,jan)" and you want to know how many times Jan appears in it, or do you have a field containing one month name and you want to know how many times each month name appears in the report?