How can I filter a dataset based on any one of multiple criteria?

Ask the community
, ,
1

Question:
I have a directory of names in a CMS collection. I want to display them in a set of repeaters (that’s all working satisfactorily) grouped by first letter of surname. I can create 26 (or 52?) datasets on the directory collection (one for each letter of the alphabet, upper case and lower case) but I’d like to reduce that to 10 (case-insensitive): ABC, DEF, GHI, JKL, MNO, PQRS, TUV, WXYZ. The obvious solution would be a filter based on a regex testing the start of the surname but I only appear to be able to test for “surname starts with a single value”.

Product:
Wix Editor

2

Already solved here?

3

Thank you for looking.
Not yet solved although one code solution might be adaptable if I were writing code to go in my page. At this stage I have only used the Wix Editor which (please point me in the right direction if I’m wrong) does not support user code.
For what I’m trying to do, a simple enhancement of the filter criteria to include some simple boolean operations and/or regex criteria would work and be simple to maintain - I hope to hand management of the site over to non-IT people with limited skills and a detailed instruction manual.