How could I count the number of vowels and consonants of a text with letters and numbers??

[jaarroyl]

Good Morning, I need help to know how to count the number of vowels and consonants of a text with letters and numbers.

I have attached the QVW, to see what i have.

To resume, I have a lot of vehicle license plates that some of them have this kind of format:

X X 1 2 3 4

and the new ones (after 2007)

X X X X 1 2

I need to order them by new plates and old plates according to the number of letters that they have.

Please help Me.!!

[sunny_talwar · Accepted solution]

You can try this

=Len(PurgeChar(VEH_PATENTE, '0123456789'))

Where the value is 2, the plate is old and where the value is 4, the plate is new.

[sunny_talwar]

Here is the one with the sorting first by New/Old criteria and then within each of them in A->Z

[jaarroyl]

Thanks you very much.

It works according what I wanted!

Regards.

[sunny_talwar]

Super, please close the thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny