Latest Activity

code

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

code

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, '...

Reg EXP