Custom Filters: How to filter by "starts with" while also using an OR statement

[nicole_defour-1]

I am trying to create a custom filter by narrowing down what a dimension starts with while also using an OR statement to include items with a specific ID.

Ex. Starts with Apple, Apple-, or Apple Pie OR is ID #1234

[Dawid]

We do not have any regex functions or starts_with but I think you could work around it with substring:

substring(${dimension}, 1, 5) = “Apple” OR substring(${dimension}, 1, 6) = “Apple-” OR ${substring(${dimension}, 1, 9) = “Apple Pie”