Skip to main content
Solved

1. How to identify special characters in column of the data ?2. How to identify the correct email address ?

  • October 21, 2021
  • 4 replies
  • 7 views
A
  • Anonymous

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.

Best answer by Anonymous

Hi @dubbaka.dines12 ,

 

Try \\ as escape character for single quote(') and [] for % e.g., '\\'' and '[%]'.

image 

Let me know if it is working for you.

4 replies

A
  • Anonymous
  • 0 replies
  • Answer
  • October 23, 2021

Hi @dubbaka.dines12 ,

 

Try \\ as escape character for single quote(') and [] for % e.g., '\\'' and '[%]'.

image 

Let me know if it is working for you.

A
  • Anonymous
  • 0 replies
  • October 25, 2021

Hi Kaustav Mandal,

 

Thanks for the syntax.

 

It's working.

A
  • Anonymous
  • 0 replies
  • October 25, 2021

Can you help me on this how to identify correct email address.

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.

janpeter.van.d
Level 12
Forum|alt.badge.img+26
  • janpeter.van.d
  • Level 12
  • 496 replies
  • May 11, 2023

Unfortunately match_regex is not a supported PQL statement and can therefore not be handled by Celonis. Please refer to PQL Function Library (celonis.com) to see all allowed statements.


Community Code of ConductAccessibility statement