|
-
January 4th, 2008, 06:32 AM
#1
Word count in a field
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?
-
January 6th, 2008, 04:19 PM
#2
Re: Word count in a field
You could use Split to get each element into an array and then loop through them.
-
January 10th, 2008, 10:28 AM
#3
Re: Word count in a field
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)"
-
January 10th, 2008, 05:21 PM
#4
Re: Word count in a 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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|