Vowels and Consonants

[EasyScott]

Hi,

I am trying to create a calculation that will tell me if a field contains 6 or more consonants and no vowels.

What I have done so far is create a field that substitutes all Vowels to show 2 and all consonants to show 1. I admit that I started out without figuring exactly what I was going to do. But my plan is to say if there are no 2's and 6 or more 1's create a mark in another field. I was thinking that I could create a calculation that would add together the numbers in the previous filed. I just cant figure out how to add together numbers in 1 field. (I am probably missing something very obvious.)

If any one has any ideas on how to accomplish my final goal or just how to add together a series of numbers in 1 field. Please let me know.

Thanks in advance,

Scott

[dreamingmind]

Scott

Perhaps the Filter() function would be simpler.

something like

filter(myfield;"aeiou")

will leave a residue of all the vowels. Checking the length of this result will tell you how many there are.

a similar calc for consonants and you're all set!

Regards,

Don

[David Jondreau]

Case(IsEmpty(Filter(myField; "aeiou")) and Length(myField) > 5; 1;0)

[EasyScott]

That is fantastic and works a treat.

Thanks,

Scott