First three consonants of a string

daniele_1306 — Wed, 06 Mar 2019 08:35:23 GMT

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

Re: First three consonants of a string

andreas_lds — Wed, 06 Mar 2019 08:46:33 GMT

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);