Counting Letters in a Field

[ABCRobstown]

I have a field with three possible entries: U, M, or ALT. I would like to have a count of each of the three entries--for example, 10 U's, 15 M's, 8 ALT.

Is this possible? I am using both FMP4 and FMP6.

Thanks in advance for your help.

[Genx]

Does the patterncount function exist in fp4 / fp6?

[mr_vodka]

Does the patterncount function exist in fp4 / fp6?

Yes it does Alex.

[Genx]

Lol, well you could've taken it from there John :

PatternCount(textField ; "U" ) & " U's " & PatternCount(textField ; "M" ) & " M's " & PatternCount(textField ; "ALT" ) & " ALT "

U, M, or ALT. I would like to have a count of each of the three entries--for example, 10 U's, 15 M's, 8 ALT.

[Ted S]

You know, I'm not sure you fellas are answering the question that he intended to ask. The title of his post makes me think that you've answered correctly but the wording in the body leads me to think that he may really want to know how many *records* have the value "U" and how many *records* have the value "M" and how many *records* have the vaule "ALT".

Maybe I'm wrong.

[Genx]

Hmmm, maybe, but they'll need patterncount either way.

[Ted S]

... but then again, he put the post in the define fields category so you're probably correct. Forget my blabbering. I'll shut-up now. Ten-Four. Over-and-out. Good bye.

[Genx]

And what's wrong with giving whiskey and car keys to teenage boys... maybe not both at once but..

[ABCRobstown]

Thanks for the help. You put me on the right track.

Here's how it was settled.

First total field:

PatternCount(TAKS Lvl 2, "Alt")

Second total field:

PatternCount(TAKS Lvl 2, "M")

Third total field:

PatternCount(TAKS Lvl 2, "U")

[Genx]

:)

[mr_vodka]

Lol, well you could've taken it from there John

Sorry Alex,

: I was half brain-dead yesterday (I'm brain-dead to begin with so that doesnt leave much room). I didnt get any sleep because of a really early flight.

[Genx]

Okey :)