Splitting word list based on syllabic structure, CVC (consonant/vowel/consonant) etc

Hi James and welcome to the forum!

You give your lists of vowels and consonants with an "etc." at the end, though it's likely that a solution to your problem would require a definitive list for each category, and I for one would not be confident of completing that list based on assumptions (appears to be a form of Irish?).

Could you please provide a comprehensive list for both vowels and consonants?

Regards

XOR LX,
hi and thanks! Yes, it's Irish. I'm trying to group the words ultimately based on their underlying pronunciation. While the spelling is more regular and 'phonetic' than English, it's hard to parse due to all the silent vowels the job of which is to show the quality of the consonant (buí and bí have different b sounds, for example).

Vowels: a, e, o, u, i, á, é, ó, ú, í, abh, ábh, adh, idh, idhe, agh, igh, ighe, amh, eamh, ith, bh, mh
Consonants: b, bh, c, ch, d, dh, f, fh, g, gh, h, j, l, ll, m, n, nn, p, ph, q, r, rr, s, sh, t, th, v, x, y, z, ibh, imh

[bh and mh re treated as consonants normally when at the start and middle (where they come from b and m and have a grammatical function) but I'm treating them as vowels as in a dictionary list they are mostly at the end ]

Due to all the possible combinations in a system set up to follow basic principles rather than strict absolute spelling so there will be on or two combos I might have missed, but I have the most of them

Try the attached workbook.

The sheet [Lookup] is used to map which letters / combinations relate to Consonants (C) or Vowels (V).

The user-defined-function then loops through all these rows, and replaces the actual letter(s) with a C or V appropriately, for the string provided.

So, you can use =CVStructure("irishword") to translate it into the CV style word structure.

Hope this makes sense!

Oh, forgot to add - then you can simply use a pivot table to group lists of words by structure.

Edit: updated workbook attached, with pivot table grouping by word structure.

Great work, Olly!!

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.