First three consonants of a string

[daniele_1306]

I would need to extract the first three consonants for each element of a list. Can someone help me?

thank you very much

LIST                 TO BE

PAROLA           PRL

LIBRO              LBR

NEWSPAPER  NWS

[andreas_lds]

Use compress-function to remove vowels, then substr to get the first three chars.

consonants = substr(compress(word, 'aeiou', 'i'), 1, 3);

if you are 100% sure that you have only upcase letters in your list, than use

consonants = substr(compress(word, 'AEIOU'), 1, 3);