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

Error_screenshot

Page 1 / 1

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

Sign up