Escape Characters for Custom Rule SQL
In PPM 9.32, I am trying to populate a read only text field based on what is chosen in a multi select auto complete list. Since the user may sleect more than one value, I am trying to use REGEXP_SUBSTR with a bracketed expression in the where clause below ([^;]):
lookup_code = REGEXP_SUBSTR('[REQ.P.STRATEGIC_ALIGN_CAT1]', '[^;]+', 1, 1)
When I try to save the Rule, it barks at me about having an ill-formatted token in my SQL. I assume that there is something in the SQL validator that sees the square brackets of my regular expression and thinks it is supposed to be reading a token.
Are there any escape characters that I can use so to make the SQL validator ignore my expression brackets?
Re: Escape Characters for Custom Rule SQL
have you tried this way?
lookup_code = REGEXP_SUBSTR('[REQ.P.STRATEGIC_ALIGN_CAT1]', chr(91)||'^;' || chr(93) || '+', 1, 1)