CQL filter needed to retrieve only the first word from page title

Question

I have a Confluence space with many similar pages.

I want to create an overview with the pages titles structured alphabetical from A-Z.

I want you to help me please to find the correct filter to show for A only the pages having in their titles the first word starting with A and only the first word.

Now I get all the pages having in their titles other words starting with A, besides the first word, which is an output I don't want.

What would be the correct regex expression to be used in the filter "With title" (see attachment).

Thank you.

Aron Gombas _Midori_ · Answer

I am afraid, you can not do this with the current capabilities of CQL operators.

The best you can get is the "~" operator, but it will test the whole text for match. For your use case, you would need something "more precise", like a regex match.

Mihai Mot · Answer

Or how to adjust the below line to get only the first word of the title starting with letter A: label = "pmt_glossary_term" and parent = "2753668694" and title ~ "A*"