Stacie Traill presented me with an interesting question- could she use Regular Expressions in Alma Analytics in order to test some data she knew was erroneous. The answer is yes, but I also offered her an alternative (and somewhat easier) method using the string functions in OBIEE. Here are videos showing both methods:
ASCII Method
Regular Expressions
Regular Expressions are very powerful, but also very challenging. OBIEE adds to the complexity, by encapsulating this function inside of its own function. One starting reference place for Oracle Regular Expression functions is Puget Sound Oracle Users Group