Latest Activity


Find occurrence of a character in a string

I have similar data as below in a field. asgbf-4567-7836-001 asgbf-4568-238965-0471 uhsnfhed-248-76398-46921-89432 AA-001-567-8934-98345-200 The requirement is to find out the occurrence of '-' in the data and extract the particular substring of data....

Reg EXP INSTR substring


Reg Expression Check in Denodo

Hi Gurus, Looking for help to find the regular expression for finding - Email Addres cannot contain more than 3 or less than 2 alpha characters after the last '.' I have tried len(substr(cont_detail_dscr , position('^^^' in REGEXP(cont_detail_dscr, '...