Skip to main content
Question

How to filter output from MATCH_PROCESS_REGEX(some statement). All the results with value=1 is expected. I am using CASE WHEN (MATCH_PROCESS_REGEX(some statement) = 1) THEN 'A' else 'B' END;However, it is not working. (error attached)Pls suggest

  • April 12, 2022
  • 1 reply
  • 1 view
.
Level 0

Error_screenshot

    1 reply

    Z
    Level 5
    • z.b
    • Level 5
    • April 13, 2022

    Hi @1460063993 ,

     

    Try using this code. Hope it helps.. I have added the LIKE functionality

    MATCH_PROCESS_REGEX ("_CEL_C2R_ACTIVITIES"."ACTIVITY_EN", LIKE '%Set Status to On Hold%')

     

    Hope this helps as I feel that your statement is not able to find that activity and hence returning zero.

     

    Regards,

    JayB

    Community Code of ConductAccessibility statement