Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jaarroyl
New Contributor III

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

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.!!

1 Solution

Accepted Solutions
MVP
MVP

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

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.

Capture.PNG

4 Replies
MVP
MVP

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

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.

Capture.PNG

MVP
MVP

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

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

Capture.PNG

jaarroyl
New Contributor III

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

Thanks you very much.

It works according what I wanted!

Regards.

MVP
MVP

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

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny