According to requirement we have tried special character to identify but unable to add ' and % in celonis. The syntax which we have used is

CASE WHEN("TABLE NAME"."COLUMN NAME") IN_LIKE ('!','@','#','$','^','*','(',')','- ','_','+','=','{','}',';',']','|','/',':',';','"','<','>',',','.','?') THEN 'CLEANSE' ELSE 'PERFECT'

 when we are adding ' and % two characters output is getting changed.

For identifying the correct email address we have got this syntax IF(match_regex($email, '&a-zA-Z0-9_\\-]+@(-a-zA-Z0-9_\\-]+\\.)+(com|org|edu|nz|au)', null))

but its not working.