Hello,
I am trying to do a count of how many times a Certain word appears in a text field. I would like to count how many times "Suit 1" and "Suit 2" appears in my database, all references would be entered in the same fields, among different records.
Thanks,
Dave
1
2 replies to this topic
#1 OFFLINE member
davefilm
-
- Members
- 8 posts
-
FM Client:11 Advance - Platform:Mac OS X Lion
- Skill Level:Intermediate
- Time Online: 6h 33m 47s
Posted 02 February 2012 - 02:17 PM
#2 OFFLINE Lifetime Student
LaRetta
-
- Members
- 8,061 posts
- LocationOregon
- Time Online: 57d 23h 32m 6s
Posted 02 February 2012 - 02:30 PM
PatternCount ( yourField ; "Suit 1" ) ... will tell you how many times it appears in the field. So create a calculation (result is number) with it.
Do you want result for found set or all records? Then create a Summary field with "Total of" and point to the above calc. This will produce total 'count' of Suite 1 for that set of records.
Do you want result for found set or all records? Then create a Summary field with "Total of" and point to the above calc. This will produce total 'count' of Suite 1 for that set of records.
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.
#3 OFFLINE member
davefilm
-
- Members
- 8 posts
-
FM Client:11 Advance - Platform:Mac OS X Lion
- Skill Level:Intermediate
- Time Online: 6h 33m 47s
Posted 02 February 2012 - 02:45 PM
thanks!!
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
FMForum Advertisers
