Oracle BI (OBIEE) - Wildcard search for numeric values only

Question

I need to set up a query that returns only the values that would match a pattern {Any character & digit} I've tried setting up a filter criteria to ' %_ [0-9] but it doesn't work...I want to exclude any results that have two letters as the first two characters of a value. Thanks!

Answer 1

In the presentation column, you can use the OBIEE - Evaluate - Embedded DB Functions in a formula.

For example (not the exact regex you are looking for but you get the point):

This link contains the same image/example I uploaded, as well as a few others: http://gerardnico.com/wiki/dat/obiee/regexp_evaluate